﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Cosea_ReclutamientoDataSet" targetNamespace="http://tempuri.org/Cosea_ReclutamientoDataSet.xsd" xmlns:mstns="http://tempuri.org/Cosea_ReclutamientoDataSet.xsd" xmlns="http://tempuri.org/Cosea_ReclutamientoDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="Cosea_ReclutamientoConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Cosea_ReclutamientoConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ReclutamientoCosea.Properties.Settings.GlobalReference.Default.Cosea_ReclutamientoConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CandidatoTableAdapter" GeneratorDataComponentClassName="CandidatoTableAdapter" Name="Candidato" UserDataComponentName="CandidatoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Cosea_ReclutamientoConnectionString (Settings)" DbObjectName="Cosea_Reclutamiento.dbo.Candidato" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Candidato] WHERE (([idcandidato] = @Original_idcandidato) AND ([idpersona] = @Original_idpersona) AND ((@IsNull_activo = 1 AND [activo] IS NULL) OR ([activo] = @Original_activo)) AND ((@IsNull_fechaalta = 1 AND [fechaalta] IS NULL) OR ([fechaalta] = @Original_fechaalta)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_idcandidato" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="idcandidato" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_idpersona" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="idpersona" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_activo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="activo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_activo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="activo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fechaalta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fechaalta" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_fechaalta" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="fechaalta" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Candidato] ([idcandidato], [idpersona], [activo], [fechaalta]) VALUES (@idcandidato, @idpersona, @activo, @fechaalta);
SELECT idcandidato, idpersona, activo, fechaalta FROM Candidato WHERE (idcandidato = @idcandidato)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@idcandidato" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="idcandidato" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@idpersona" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="idpersona" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@activo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="activo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@fechaalta" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="fechaalta" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idcandidato, idpersona, activo, fechaalta FROM dbo.Candidato</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Candidato] SET [idcandidato] = @idcandidato, [idpersona] = @idpersona, [activo] = @activo, [fechaalta] = @fechaalta WHERE (([idcandidato] = @Original_idcandidato) AND ([idpersona] = @Original_idpersona) AND ((@IsNull_activo = 1 AND [activo] IS NULL) OR ([activo] = @Original_activo)) AND ((@IsNull_fechaalta = 1 AND [fechaalta] IS NULL) OR ([fechaalta] = @Original_fechaalta)));
SELECT idcandidato, idpersona, activo, fechaalta FROM Candidato WHERE (idcandidato = @idcandidato)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@idcandidato" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="idcandidato" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@idpersona" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="idpersona" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@activo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="activo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@fechaalta" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="fechaalta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_idcandidato" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="idcandidato" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_idpersona" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="idpersona" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_activo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="activo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_activo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="activo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fechaalta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fechaalta" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_fechaalta" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="fechaalta" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idcandidato" DataSetColumn="idcandidato" />
              <Mapping SourceColumn="idpersona" DataSetColumn="idpersona" />
              <Mapping SourceColumn="activo" DataSetColumn="activo" />
              <Mapping SourceColumn="fechaalta" DataSetColumn="fechaalta" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CurriculumTableAdapter" GeneratorDataComponentClassName="CurriculumTableAdapter" Name="Curriculum" UserDataComponentName="CurriculumTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Cosea_ReclutamientoConnectionString (Settings)" DbObjectName="Cosea_Reclutamiento.dbo.Curriculum" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Curriculum] WHERE (([idcurriculum] = @Original_idcurriculum) AND ([idcandidato] = @Original_idcandidato) AND ((@IsNull_nombrecompleto = 1 AND [nombrecompleto] IS NULL) OR ([nombrecompleto] = @Original_nombrecompleto)) AND ((@IsNull_expectativasprofesionales = 1 AND [expectativasprofesionales] IS NULL) OR ([expectativasprofesionales] = @Original_expectativasprofesionales)) AND ((@IsNull_estudiosrealizados = 1 AND [estudiosrealizados] IS NULL) OR ([estudiosrealizados] = @Original_estudiosrealizados)) AND ((@IsNull_experienciaprofesional = 1 AND [experienciaprofesional] IS NULL) OR ([experienciaprofesional] = @Original_experienciaprofesional)) AND ((@IsNull_competencias = 1 AND [competencias] IS NULL) OR ([competencias] = @Original_competencias)) AND ((@IsNull_habilidades = 1 AND [habilidades] IS NULL) OR ([habilidades] = @Original_habilidades)) AND ((@IsNull_fechaalta = 1 AND [fechaalta] IS NULL) OR ([fechaalta] = @Original_fechaalta)) AND ((@IsNull_activo = 1 AND [activo] IS NULL) OR ([activo] = @Original_activo)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_idcurriculum" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="idcurriculum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_idcandidato" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="idcandidato" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nombrecompleto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nombrecompleto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_nombrecompleto" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="nombrecompleto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_expectativasprofesionales" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="expectativasprofesionales" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_expectativasprofesionales" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="expectativasprofesionales" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_estudiosrealizados" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="estudiosrealizados" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_estudiosrealizados" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="estudiosrealizados" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_experienciaprofesional" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="experienciaprofesional" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_experienciaprofesional" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="experienciaprofesional" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_competencias" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="competencias" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_competencias" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="competencias" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_habilidades" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="habilidades" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_habilidades" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="habilidades" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fechaalta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fechaalta" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_fechaalta" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="fechaalta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_activo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="activo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_activo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="activo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Curriculum] ([idcurriculum], [idcandidato], [nombrecompleto], [expectativasprofesionales], [estudiosrealizados], [experienciaprofesional], [competencias], [habilidades], [fechaalta], [activo]) VALUES (@idcurriculum, @idcandidato, @nombrecompleto, @expectativasprofesionales, @estudiosrealizados, @experienciaprofesional, @competencias, @habilidades, @fechaalta, @activo);
SELECT idcurriculum, idcandidato, nombrecompleto, expectativasprofesionales, estudiosrealizados, experienciaprofesional, competencias, habilidades, fechaalta, activo FROM Curriculum WHERE (idcurriculum = @idcurriculum)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@idcurriculum" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="idcurriculum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@idcandidato" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="idcandidato" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@nombrecompleto" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="nombrecompleto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@expectativasprofesionales" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="expectativasprofesionales" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@estudiosrealizados" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="estudiosrealizados" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@experienciaprofesional" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="experienciaprofesional" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@competencias" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="competencias" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@habilidades" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="habilidades" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@fechaalta" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="fechaalta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@activo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="activo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idcurriculum, idcandidato, nombrecompleto, expectativasprofesionales, estudiosrealizados, experienciaprofesional, competencias, habilidades, fechaalta, activo FROM dbo.Curriculum</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Curriculum] SET [idcurriculum] = @idcurriculum, [idcandidato] = @idcandidato, [nombrecompleto] = @nombrecompleto, [expectativasprofesionales] = @expectativasprofesionales, [estudiosrealizados] = @estudiosrealizados, [experienciaprofesional] = @experienciaprofesional, [competencias] = @competencias, [habilidades] = @habilidades, [fechaalta] = @fechaalta, [activo] = @activo WHERE (([idcurriculum] = @Original_idcurriculum) AND ([idcandidato] = @Original_idcandidato) AND ((@IsNull_nombrecompleto = 1 AND [nombrecompleto] IS NULL) OR ([nombrecompleto] = @Original_nombrecompleto)) AND ((@IsNull_expectativasprofesionales = 1 AND [expectativasprofesionales] IS NULL) OR ([expectativasprofesionales] = @Original_expectativasprofesionales)) AND ((@IsNull_estudiosrealizados = 1 AND [estudiosrealizados] IS NULL) OR ([estudiosrealizados] = @Original_estudiosrealizados)) AND ((@IsNull_experienciaprofesional = 1 AND [experienciaprofesional] IS NULL) OR ([experienciaprofesional] = @Original_experienciaprofesional)) AND ((@IsNull_competencias = 1 AND [competencias] IS NULL) OR ([competencias] = @Original_competencias)) AND ((@IsNull_habilidades = 1 AND [habilidades] IS NULL) OR ([habilidades] = @Original_habilidades)) AND ((@IsNull_fechaalta = 1 AND [fechaalta] IS NULL) OR ([fechaalta] = @Original_fechaalta)) AND ((@IsNull_activo = 1 AND [activo] IS NULL) OR ([activo] = @Original_activo)));
SELECT idcurriculum, idcandidato, nombrecompleto, expectativasprofesionales, estudiosrealizados, experienciaprofesional, competencias, habilidades, fechaalta, activo FROM Curriculum WHERE (idcurriculum = @idcurriculum)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@idcurriculum" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="idcurriculum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@idcandidato" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="idcandidato" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@nombrecompleto" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="nombrecompleto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@expectativasprofesionales" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="expectativasprofesionales" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@estudiosrealizados" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="estudiosrealizados" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@experienciaprofesional" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="experienciaprofesional" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@competencias" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="competencias" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@habilidades" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="habilidades" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@fechaalta" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="fechaalta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@activo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="activo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_idcurriculum" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="idcurriculum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_idcandidato" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="idcandidato" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nombrecompleto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nombrecompleto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_nombrecompleto" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="nombrecompleto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_expectativasprofesionales" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="expectativasprofesionales" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_expectativasprofesionales" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="expectativasprofesionales" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_estudiosrealizados" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="estudiosrealizados" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_estudiosrealizados" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="estudiosrealizados" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_experienciaprofesional" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="experienciaprofesional" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_experienciaprofesional" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="experienciaprofesional" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_competencias" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="competencias" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_competencias" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="competencias" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_habilidades" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="habilidades" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_habilidades" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="habilidades" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fechaalta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fechaalta" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_fechaalta" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="fechaalta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_activo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="activo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_activo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="activo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idcurriculum" DataSetColumn="idcurriculum" />
              <Mapping SourceColumn="idcandidato" DataSetColumn="idcandidato" />
              <Mapping SourceColumn="nombrecompleto" DataSetColumn="nombrecompleto" />
              <Mapping SourceColumn="expectativasprofesionales" DataSetColumn="expectativasprofesionales" />
              <Mapping SourceColumn="estudiosrealizados" DataSetColumn="estudiosrealizados" />
              <Mapping SourceColumn="experienciaprofesional" DataSetColumn="experienciaprofesional" />
              <Mapping SourceColumn="competencias" DataSetColumn="competencias" />
              <Mapping SourceColumn="habilidades" DataSetColumn="habilidades" />
              <Mapping SourceColumn="fechaalta" DataSetColumn="fechaalta" />
              <Mapping SourceColumn="activo" DataSetColumn="activo" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EntrevistaCoseaTableAdapter" GeneratorDataComponentClassName="EntrevistaCoseaTableAdapter" Name="EntrevistaCosea" UserDataComponentName="EntrevistaCoseaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Cosea_ReclutamientoConnectionString (Settings)" DbObjectName="Cosea_Reclutamiento.dbo.EntrevistaCosea" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[EntrevistaCosea] WHERE (([idcandidato] = @Original_idcandidato) AND ([identrecosea] = @Original_identrecosea) AND ([idusuario] = @Original_idusuario) AND ((@IsNull_fecha = 1 AND [fecha] IS NULL) OR ([fecha] = @Original_fecha)) AND ((@IsNull_estadocivil = 1 AND [estadocivil] IS NULL) OR ([estadocivil] = @Original_estadocivil)) AND ((@IsNull_hijos = 1 AND [hijos] IS NULL) OR ([hijos] = @Original_hijos)) AND ((@IsNull_valores = 1 AND [valores] IS NULL) OR ([valores] = @Original_valores)) AND ((@IsNull_descripcion = 1 AND [descripcion] IS NULL) OR ([descripcion] = @Original_descripcion)) AND ((@IsNull_defectos = 1 AND [defectos] IS NULL) OR ([defectos] = @Original_defectos)) AND ((@IsNull_primaria = 1 AND [primaria] IS NULL) OR ([primaria] = @Original_primaria)) AND ((@IsNull_secundaria = 1 AND [secundaria] IS NULL) OR ([secundaria] = @Original_secundaria)) AND ((@IsNull_tecnico = 1 AND [tecnico] IS NULL) OR ([tecnico] = @Original_tecnico)) AND ((@IsNull_comercial = 1 AND [comercial] IS NULL) OR ([comercial] = @Original_comercial)) AND ((@IsNull_titulado = 1 AND [titulado] IS NULL) OR ([titulado] = @Original_titulado)) AND ((@IsNull_preparatoria = 1 AND [preparatoria] IS NULL) OR ([preparatoria] = @Original_preparatoria)) AND ((@IsNull_profesional = 1 AND [profesional] IS NULL) OR ([profesional] = @Original_profesional)) AND ((@IsNull_maestria = 1 AND [maestria] IS NULL) OR ([maestria] = @Original_maestria)) AND ((@IsNull_otros = 1 AND [otros] IS NULL) OR ([otros] = @Original_otros)) AND ((@IsNull_pasante = 1 AND [pasante] IS NULL) OR ([pasante] = @Original_pasante)) AND ((@IsNull_trunco = 1 AND [trunco] IS NULL) OR ([trunco] = @Original_trunco)) AND ((@IsNull_carrera = 1 AND [carrera] IS NULL) OR ([carrera] = @Original_carrera)) AND ((@IsNull_nombreescuela = 1 AND [nombreescuela] IS NULL) OR ([nombreescuela] = @Original_nombreescuela)) AND ((@IsNull_estudia = 1 AND [estudia] IS NULL) OR ([estudia] = @Original_estudia)) AND ((@IsNull_queestudia = 1 AND [queestudia] IS NULL) OR ([queestudia] = @Original_queestudia)) AND ((@IsNull_horario = 1 AND [horario] IS NULL) OR ([horario] = @Original_horario)) AND ((@IsNull_escuela = 1 AND [escuela] IS NULL) OR ([escuela] = @Original_escuela)) AND ((@IsNull_idioma = 1 AND [idioma] IS NULL) OR ([idioma] = @Original_idioma)) AND ((@IsNull_maquinasoficina = 1 AND [maquinasoficina] IS NULL) OR ([maquinasoficina] = @Original_maquinasoficina)) AND ((@IsNull_habilidadescomputacionales = 1 AND [habilidadescomputacionales] IS NULL) OR ([habilidadescomputacionales] = @Original_habilidadescomputacionales)) AND ((@IsNull_cursostomados = 1 AND [cursostomados] IS NULL) OR ([cursostomados] = @Original_cursostomados)) AND ((@IsNull_yatrabajoenpuesto = 1 AND [yatrabajoenpuesto] IS NULL) OR ([yatrabajoenpuesto] = @Original_yatrabajoenpuesto)) AND ((@IsNull_experiencia = 1 AND [experiencia] IS NULL) OR ([experiencia] = @Original_experiencia)) AND ((@IsNull_empresasimilar = 1 AND [empresasimilar] IS NULL) OR ([empresasimilar] = @Original_empresasimilar)) AND ((@IsNull_afiliadoimss = 1 AND [afiliadoimss] IS NULL) OR ([afiliadoimss] = @Original_afiliadoimss)) AND ((@IsNull_rfc = 1 AND [rfc] IS NULL) OR ([rfc] = @Original_rfc)) AND ((@IsNull_curp = 1 AND [curp] IS NULL) OR ([curp] = @Original_curp)) AND ((@IsNull_licencia = 1 AND [licencia] IS NULL) OR ([licencia] = @Original_licencia)) AND ((@IsNull_tipolicencia = 1 AND [tipolicencia] IS NULL) OR ([tipolicencia] = @Original_tipolicencia)) AND ((@IsNull_cartilla = 1 AND [cartilla] IS NULL) OR ([cartilla] = @Original_cartilla)) AND ((@IsNull_cartillanumero = 1 AND [cartillanumero] IS NULL) OR ([cartillanumero] = @Original_cartillanumero)) AND ((@IsNull_casapropia = 1 AND [casapropia] IS NULL) OR ([casapropia] = @Original_casapropia)) AND ((@IsNull_casarentada = 1 AND [casarentada] IS NULL) OR ([casarentada] = @Original_casarentada)) AND ((@IsNull_casaprestada = 1 AND [casaprestada] IS NULL) OR ([casaprestada] = @Original_casaprestada)) AND ((@IsNull_tiempoviviendo = 1 AND [tiempoviviendo] IS NULL) OR ([tiempoviviendo] = @Original_tiempoviviendo)) AND ((@IsNull_vivecon = 1 AND [vivecon] IS NULL) OR ([vivecon] = @Original_vivecon)) AND ((@IsNull_otroingreso = 1 AND [otroingreso] IS NULL) OR ([otroingreso] = @Original_otroingreso)) AND ((@IsNull_personasdependientes = 1 AND [personasdependientes] IS NULL) OR ([personasdependientes] = @Original_personasdependientes)) AND ((@IsNull_gastosmensuales = 1 AND [gastosmensuales] IS NULL) OR ([gastosmensuales] = @Original_gastosmensuales)) AND ((@IsNull_aportacionhogar = 1 AND [aportacionhogar] IS NULL) OR ([aportacionhogar] = @Original_aportacionhogar)) AND ((@IsNull_automovilpropio = 1 AND [automovilpropio] IS NULL) OR ([automovilpropio] = @Original_automovilpropio)) AND ((@IsNull_modeloauto = 1 AND [modeloauto] IS NULL) OR ([modeloauto] = @Original_modeloauto)) AND ((@IsNull_tienecredito = 1 AND [tienecredito] IS NULL) OR ([tienecredito] = @Original_tienecredito)) AND ((@IsNull_deudas = 1 AND [deudas] IS NULL) OR ([deudas] = @Original_deudas)) AND ((@IsNull_abonomensual = 1 AND [abonomensual] IS NULL) OR ([abonomensual] = @Original_abonomensual)) AND ((@IsNull_salud = 1 AND [salud] IS NULL) OR ([salud] = @Original_salud)) AND ((@IsNull_enfermedadcronica = 1 AND [enfermedadcronica] IS NULL) OR ([enfermedadcronica] = @Original_enfermedadcronica)) AND ((@IsNull_cualcronica = 1 AND [cualcronica] IS NULL) OR ([cualcronica] = @Original_cualcronica)) AND ((@IsNull_enfermedadqueimpida = 1 AND [enfermedadqueimpida] IS NULL) OR ([enfermedadqueimpida] = @Original_enfermedadqueimpida)) AND ((@IsNull_cualimpida = 1 AND [cualimpida] IS NULL) OR ([cualimpida] = @Original_cualimpida)) AND ((@IsNull_enfermedadcontagiosa = 1 AND [enfermedadcontagiosa] IS NULL) OR ([enfermedadcontagiosa] = @Original_enfermedadcontagiosa)) AND ((@IsNull_cualcontagiosa = 1 AND [cualcontagiosa] IS NULL) OR ([cualcontagiosa] = @Original_cualcontagiosa)) AND ((@IsNull_cuantasincapacidades = 1 AND [cuantasincapacidades] IS NULL) OR ([cuantasincapacidades] = @Original_cuantasincapacidades)) AND ((@IsNull_motivoincapacidad = 1 AND [motivoincapacidad] IS NULL) OR ([motivoincapacidad] = @Original_motivoincapacidad)) AND ((@IsNull_consumirdroga = 1 AND [consumirdroga] IS NULL) OR ([consumirdroga] = @Original_consumirdroga)) AND ((@IsNull_tipodroga = 1 AND [tipodroga] IS NULL) OR ([tipodroga] = @Original_tipodroga)) AND ((@IsNull_fuma = 1 AND [fuma] IS NULL) OR ([fuma] = @Original_fuma)) AND ((@IsNull_tomaalcohol = 1 AND [tomaalcohol] IS NULL) OR ([tomaalcohol] = @Original_tomaalcohol)) AND ((@IsNull_metacorto = 1 AND [metacorto] IS NULL) OR ([metacorto] = @Original_metacorto)) AND ((@IsNull_metamediando = 1 AND [metamediando] IS NULL) OR ([metamediando] = @Original_metamediando)) AND ((@IsNull_metalargo = 1 AND [metalargo] IS NULL) OR ([metalargo] = @Original_metalargo)) AND ((@IsNull_examenesdroga = 1 AND [examenesdroga] IS NULL) OR ([examenesdroga] = @Original_examenesdroga)) AND ((@IsNull_comentarios = 1 AND [comentarios] IS NULL) OR ([comentarios] = @Original_comentarios)) AND ((@IsNull_casapadres = 1 AND [casapadres] IS NULL) OR ([casapadres] = @Original_casapadres)) AND ((@IsNull_cualotradroga = 1 AND [cualotradroga] IS NULL) OR ([cualotradroga] = @Original_cualotradroga)) AND ((@IsNull_salariodeseado = 1 AND [salariodeseado] IS NULL) OR ([salariodeseado] = @Original_salariodeseado)) AND ((@IsNull_disponibilidadhorario = 1 AND [disponibilidadhorario] IS NULL) OR ([disponibilidadhorario] = @Original_disponibilidadhorario)) AND ((@IsNull_disponibilidadviajar = 1 AND [disponibilidadviajar] IS NULL) OR ([disponibilidadviajar] = @Original_disponibilidadviajar)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_idcandidato" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="idcandidato" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_identrecosea" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="identrecosea" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_idusuario" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="idusuario" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fecha" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_fecha" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_estadocivil" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="estadocivil" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_estadocivil" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="estadocivil" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hijos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hijos" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_hijos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hijos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_valores" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="valores" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_valores" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="valores" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_descripcion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_descripcion" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_defectos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="defectos" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_defectos" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="defectos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_primaria" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="primaria" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_primaria" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="primaria" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_secundaria" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="secundaria" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_secundaria" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="secundaria" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tecnico" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tecnico" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_tecnico" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="tecnico" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_comercial" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="comercial" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_comercial" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="comercial" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_titulado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="titulado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_titulado" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="titulado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_preparatoria" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="preparatoria" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_preparatoria" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="preparatoria" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_profesional" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="profesional" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_profesional" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="profesional" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maestria" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maestria" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_maestria" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="maestria" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_otros" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="otros" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_otros" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="otros" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pasante" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pasante" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_pasante" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="pasante" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_trunco" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="trunco" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_trunco" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="trunco" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_carrera" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="carrera" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_carrera" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="carrera" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nombreescuela" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nombreescuela" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_nombreescuela" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="nombreescuela" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_estudia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="estudia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_estudia" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="estudia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_queestudia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="queestudia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_queestudia" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="queestudia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_horario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="horario" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_horario" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="horario" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_escuela" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="escuela" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_escuela" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="escuela" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idioma" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idioma" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_idioma" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="idioma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maquinasoficina" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maquinasoficina" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_maquinasoficina" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="maquinasoficina" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_habilidadescomputacionales" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="habilidadescomputacionales" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_habilidadescomputacionales" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="habilidadescomputacionales" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cursostomados" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cursostomados" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_cursostomados" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cursostomados" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_yatrabajoenpuesto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="yatrabajoenpuesto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_yatrabajoenpuesto" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="yatrabajoenpuesto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_experiencia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="experiencia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_experiencia" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="experiencia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_empresasimilar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="empresasimilar" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_empresasimilar" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="empresasimilar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_afiliadoimss" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="afiliadoimss" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_afiliadoimss" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="afiliadoimss" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_rfc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="rfc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_rfc" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="rfc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_curp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="curp" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_curp" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="curp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_licencia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="licencia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_licencia" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="licencia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tipolicencia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tipolicencia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_tipolicencia" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="tipolicencia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cartilla" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cartilla" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_cartilla" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cartilla" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cartillanumero" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cartillanumero" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_cartillanumero" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cartillanumero" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_casapropia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="casapropia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_casapropia" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="casapropia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_casarentada" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="casarentada" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_casarentada" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="casarentada" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_casaprestada" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="casaprestada" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_casaprestada" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="casaprestada" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tiempoviviendo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tiempoviviendo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_tiempoviviendo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tiempoviviendo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_vivecon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="vivecon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_vivecon" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="vivecon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_otroingreso" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="otroingreso" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_otroingreso" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="otroingreso" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_personasdependientes" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="personasdependientes" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_personasdependientes" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="personasdependientes" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_gastosmensuales" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gastosmensuales" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_gastosmensuales" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="gastosmensuales" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_aportacionhogar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="aportacionhogar" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_aportacionhogar" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="aportacionhogar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_automovilpropio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="automovilpropio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_automovilpropio" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="automovilpropio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_modeloauto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="modeloauto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_modeloauto" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="modeloauto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tienecredito" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tienecredito" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_tienecredito" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="tienecredito" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_deudas" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deudas" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_deudas" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="deudas" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_abonomensual" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="abonomensual" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_abonomensual" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="abonomensual" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_salud" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="salud" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_salud" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="salud" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_enfermedadcronica" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="enfermedadcronica" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_enfermedadcronica" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="enfermedadcronica" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cualcronica" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cualcronica" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_cualcronica" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cualcronica" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_enfermedadqueimpida" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="enfermedadqueimpida" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_enfermedadqueimpida" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="enfermedadqueimpida" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cualimpida" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cualimpida" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_cualimpida" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cualimpida" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_enfermedadcontagiosa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="enfermedadcontagiosa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_enfermedadcontagiosa" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="enfermedadcontagiosa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cualcontagiosa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cualcontagiosa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_cualcontagiosa" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cualcontagiosa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cuantasincapacidades" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cuantasincapacidades" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_cuantasincapacidades" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cuantasincapacidades" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_motivoincapacidad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="motivoincapacidad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_motivoincapacidad" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="motivoincapacidad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_consumirdroga" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="consumirdroga" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_consumirdroga" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="consumirdroga" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tipodroga" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tipodroga" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_tipodroga" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="tipodroga" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fuma" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fuma" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_fuma" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="fuma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tomaalcohol" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tomaalcohol" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_tomaalcohol" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="tomaalcohol" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_metacorto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="metacorto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_metacorto" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="metacorto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_metamediando" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="metamediando" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_metamediando" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="metamediando" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_metalargo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="metalargo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_metalargo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="metalargo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_examenesdroga" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="examenesdroga" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_examenesdroga" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="examenesdroga" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_comentarios" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="comentarios" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_comentarios" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="comentarios" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_casapadres" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="casapadres" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_casapadres" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="casapadres" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cualotradroga" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cualotradroga" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_cualotradroga" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cualotradroga" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_salariodeseado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="salariodeseado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_salariodeseado" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="salariodeseado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_disponibilidadhorario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="disponibilidadhorario" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_disponibilidadhorario" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="disponibilidadhorario" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_disponibilidadviajar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="disponibilidadviajar" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_disponibilidadviajar" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="disponibilidadviajar" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[EntrevistaCosea] ([idcandidato], [identrecosea], [idusuario], [fecha], [estadocivil], [hijos], [valores], [descripcion], [defectos], [primaria], [secundaria], [tecnico], [comercial], [titulado], [preparatoria], [profesional], [maestria], [otros], [pasante], [trunco], [carrera], [nombreescuela], [estudia], [queestudia], [horario], [escuela], [idioma], [maquinasoficina], [habilidadescomputacionales], [cursostomados], [yatrabajoenpuesto], [experiencia], [empresasimilar], [afiliadoimss], [rfc], [curp], [licencia], [tipolicencia], [cartilla], [cartillanumero], [casapropia], [casarentada], [casaprestada], [tiempoviviendo], [vivecon], [otroingreso], [personasdependientes], [gastosmensuales], [aportacionhogar], [automovilpropio], [modeloauto], [tienecredito], [deudas], [abonomensual], [salud], [enfermedadcronica], [cualcronica], [enfermedadqueimpida], [cualimpida], [enfermedadcontagiosa], [cualcontagiosa], [cuantasincapacidades], [motivoincapacidad], [consumirdroga], [tipodroga], [fuma], [tomaalcohol], [metacorto], [metamediando], [metalargo], [examenesdroga], [comentarios], [casapadres], [cualotradroga], [salariodeseado], [disponibilidadhorario], [disponibilidadviajar]) VALUES (@idcandidato, @identrecosea, @idusuario, @fecha, @estadocivil, @hijos, @valores, @descripcion, @defectos, @primaria, @secundaria, @tecnico, @comercial, @titulado, @preparatoria, @profesional, @maestria, @otros, @pasante, @trunco, @carrera, @nombreescuela, @estudia, @queestudia, @horario, @escuela, @idioma, @maquinasoficina, @habilidadescomputacionales, @cursostomados, @yatrabajoenpuesto, @experiencia, @empresasimilar, @afiliadoimss, @rfc, @curp, @licencia, @tipolicencia, @cartilla, @cartillanumero, @casapropia, @casarentada, @casaprestada, @tiempoviviendo, @vivecon, @otroingreso, @personasdependientes, @gastosmensuales, @aportacionhogar, @automovilpropio, @modeloauto, @tienecredito, @deudas, @abonomensual, @salud, @enfermedadcronica, @cualcronica, @enfermedadqueimpida, @cualimpida, @enfermedadcontagiosa, @cualcontagiosa, @cuantasincapacidades, @motivoincapacidad, @consumirdroga, @tipodroga, @fuma, @tomaalcohol, @metacorto, @metamediando, @metalargo, @examenesdroga, @comentarios, @casapadres, @cualotradroga, @salariodeseado, @disponibilidadhorario, @disponibilidadviajar);
SELECT idcandidato, identrecosea, idusuario, fecha, estadocivil, hijos, valores, descripcion, defectos, primaria, secundaria, tecnico, comercial, titulado, preparatoria, profesional, maestria, otros, pasante, trunco, carrera, nombreescuela, estudia, queestudia, horario, escuela, idioma, maquinasoficina, habilidadescomputacionales, cursostomados, yatrabajoenpuesto, experiencia, empresasimilar, afiliadoimss, rfc, curp, licencia, tipolicencia, cartilla, cartillanumero, casapropia, casarentada, casaprestada, tiempoviviendo, vivecon, otroingreso, personasdependientes, gastosmensuales, aportacionhogar, automovilpropio, modeloauto, tienecredito, deudas, abonomensual, salud, enfermedadcronica, cualcronica, enfermedadqueimpida, cualimpida, enfermedadcontagiosa, cualcontagiosa, cuantasincapacidades, motivoincapacidad, consumirdroga, tipodroga, fuma, tomaalcohol, metacorto, metamediando, metalargo, examenesdroga, comentarios, casapadres, cualotradroga, salariodeseado, disponibilidadhorario, disponibilidadviajar FROM EntrevistaCosea WHERE (identrecosea = @identrecosea)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@idcandidato" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="idcandidato" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@identrecosea" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="identrecosea" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@idusuario" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="idusuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@fecha" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@estadocivil" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="estadocivil" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@hijos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hijos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@valores" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="valores" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@descripcion" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@defectos" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="defectos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@primaria" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="primaria" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@secundaria" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="secundaria" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@tecnico" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="tecnico" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@comercial" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="comercial" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@titulado" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="titulado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@preparatoria" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="preparatoria" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@profesional" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="profesional" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@maestria" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="maestria" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@otros" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="otros" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@pasante" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="pasante" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@trunco" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="trunco" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@carrera" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="carrera" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@nombreescuela" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="nombreescuela" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@estudia" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="estudia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@queestudia" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="queestudia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@horario" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="horario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@escuela" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="escuela" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@idioma" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="idioma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@maquinasoficina" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="maquinasoficina" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@habilidadescomputacionales" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="habilidadescomputacionales" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@cursostomados" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cursostomados" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@yatrabajoenpuesto" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="yatrabajoenpuesto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@experiencia" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="experiencia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@empresasimilar" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="empresasimilar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@afiliadoimss" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="afiliadoimss" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@rfc" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="rfc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@curp" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="curp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@licencia" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="licencia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@tipolicencia" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="tipolicencia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@cartilla" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cartilla" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@cartillanumero" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cartillanumero" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@casapropia" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="casapropia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@casarentada" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="casarentada" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@casaprestada" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="casaprestada" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@tiempoviviendo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tiempoviviendo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@vivecon" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="vivecon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@otroingreso" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="otroingreso" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@personasdependientes" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="personasdependientes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@gastosmensuales" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="gastosmensuales" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@aportacionhogar" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="aportacionhogar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@automovilpropio" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="automovilpropio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@modeloauto" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="modeloauto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@tienecredito" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="tienecredito" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@deudas" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="deudas" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@abonomensual" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="abonomensual" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@salud" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="salud" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@enfermedadcronica" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="enfermedadcronica" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@cualcronica" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cualcronica" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@enfermedadqueimpida" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="enfermedadqueimpida" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@cualimpida" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cualimpida" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@enfermedadcontagiosa" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="enfermedadcontagiosa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@cualcontagiosa" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cualcontagiosa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@cuantasincapacidades" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cuantasincapacidades" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@motivoincapacidad" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="motivoincapacidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@consumirdroga" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="consumirdroga" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@tipodroga" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="tipodroga" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@fuma" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="fuma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@tomaalcohol" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="tomaalcohol" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@metacorto" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="metacorto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@metamediando" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="metamediando" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@metalargo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="metalargo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@examenesdroga" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="examenesdroga" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@comentarios" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="comentarios" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@casapadres" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="casapadres" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@cualotradroga" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cualotradroga" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@salariodeseado" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="salariodeseado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@disponibilidadhorario" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="disponibilidadhorario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@disponibilidadviajar" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="disponibilidadviajar" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idcandidato, identrecosea, idusuario, fecha, estadocivil, hijos, valores, descripcion, defectos, primaria, secundaria, tecnico, comercial, titulado, preparatoria, profesional, maestria, otros, pasante, trunco, carrera, nombreescuela, estudia, queestudia, horario, escuela, idioma, maquinasoficina, habilidadescomputacionales, cursostomados, yatrabajoenpuesto, experiencia, empresasimilar, afiliadoimss, rfc, curp, licencia, tipolicencia, cartilla, cartillanumero, casapropia, casarentada, casaprestada, tiempoviviendo, vivecon, otroingreso, personasdependientes, gastosmensuales, aportacionhogar, automovilpropio, modeloauto, tienecredito, deudas, abonomensual, salud, enfermedadcronica, cualcronica, enfermedadqueimpida, cualimpida, enfermedadcontagiosa, cualcontagiosa, cuantasincapacidades, motivoincapacidad, consumirdroga, tipodroga, fuma, tomaalcohol, metacorto, metamediando, metalargo, examenesdroga, comentarios, casapadres, cualotradroga, salariodeseado, disponibilidadhorario, disponibilidadviajar FROM dbo.EntrevistaCosea</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[EntrevistaCosea] SET [idcandidato] = @idcandidato, [identrecosea] = @identrecosea, [idusuario] = @idusuario, [fecha] = @fecha, [estadocivil] = @estadocivil, [hijos] = @hijos, [valores] = @valores, [descripcion] = @descripcion, [defectos] = @defectos, [primaria] = @primaria, [secundaria] = @secundaria, [tecnico] = @tecnico, [comercial] = @comercial, [titulado] = @titulado, [preparatoria] = @preparatoria, [profesional] = @profesional, [maestria] = @maestria, [otros] = @otros, [pasante] = @pasante, [trunco] = @trunco, [carrera] = @carrera, [nombreescuela] = @nombreescuela, [estudia] = @estudia, [queestudia] = @queestudia, [horario] = @horario, [escuela] = @escuela, [idioma] = @idioma, [maquinasoficina] = @maquinasoficina, [habilidadescomputacionales] = @habilidadescomputacionales, [cursostomados] = @cursostomados, [yatrabajoenpuesto] = @yatrabajoenpuesto, [experiencia] = @experiencia, [empresasimilar] = @empresasimilar, [afiliadoimss] = @afiliadoimss, [rfc] = @rfc, [curp] = @curp, [licencia] = @licencia, [tipolicencia] = @tipolicencia, [cartilla] = @cartilla, [cartillanumero] = @cartillanumero, [casapropia] = @casapropia, [casarentada] = @casarentada, [casaprestada] = @casaprestada, [tiempoviviendo] = @tiempoviviendo, [vivecon] = @vivecon, [otroingreso] = @otroingreso, [personasdependientes] = @personasdependientes, [gastosmensuales] = @gastosmensuales, [aportacionhogar] = @aportacionhogar, [automovilpropio] = @automovilpropio, [modeloauto] = @modeloauto, [tienecredito] = @tienecredito, [deudas] = @deudas, [abonomensual] = @abonomensual, [salud] = @salud, [enfermedadcronica] = @enfermedadcronica, [cualcronica] = @cualcronica, [enfermedadqueimpida] = @enfermedadqueimpida, [cualimpida] = @cualimpida, [enfermedadcontagiosa] = @enfermedadcontagiosa, [cualcontagiosa] = @cualcontagiosa, [cuantasincapacidades] = @cuantasincapacidades, [motivoincapacidad] = @motivoincapacidad, [consumirdroga] = @consumirdroga, [tipodroga] = @tipodroga, [fuma] = @fuma, [tomaalcohol] = @tomaalcohol, [metacorto] = @metacorto, [metamediando] = @metamediando, [metalargo] = @metalargo, [examenesdroga] = @examenesdroga, [comentarios] = @comentarios, [casapadres] = @casapadres, [cualotradroga] = @cualotradroga, [salariodeseado] = @salariodeseado, [disponibilidadhorario] = @disponibilidadhorario, [disponibilidadviajar] = @disponibilidadviajar WHERE (([idcandidato] = @Original_idcandidato) AND ([identrecosea] = @Original_identrecosea) AND ([idusuario] = @Original_idusuario) AND ((@IsNull_fecha = 1 AND [fecha] IS NULL) OR ([fecha] = @Original_fecha)) AND ((@IsNull_estadocivil = 1 AND [estadocivil] IS NULL) OR ([estadocivil] = @Original_estadocivil)) AND ((@IsNull_hijos = 1 AND [hijos] IS NULL) OR ([hijos] = @Original_hijos)) AND ((@IsNull_valores = 1 AND [valores] IS NULL) OR ([valores] = @Original_valores)) AND ((@IsNull_descripcion = 1 AND [descripcion] IS NULL) OR ([descripcion] = @Original_descripcion)) AND ((@IsNull_defectos = 1 AND [defectos] IS NULL) OR ([defectos] = @Original_defectos)) AND ((@IsNull_primaria = 1 AND [primaria] IS NULL) OR ([primaria] = @Original_primaria)) AND ((@IsNull_secundaria = 1 AND [secundaria] IS NULL) OR ([secundaria] = @Original_secundaria)) AND ((@IsNull_tecnico = 1 AND [tecnico] IS NULL) OR ([tecnico] = @Original_tecnico)) AND ((@IsNull_comercial = 1 AND [comercial] IS NULL) OR ([comercial] = @Original_comercial)) AND ((@IsNull_titulado = 1 AND [titulado] IS NULL) OR ([titulado] = @Original_titulado)) AND ((@IsNull_preparatoria = 1 AND [preparatoria] IS NULL) OR ([preparatoria] = @Original_preparatoria)) AND ((@IsNull_profesional = 1 AND [profesional] IS NULL) OR ([profesional] = @Original_profesional)) AND ((@IsNull_maestria = 1 AND [maestria] IS NULL) OR ([maestria] = @Original_maestria)) AND ((@IsNull_otros = 1 AND [otros] IS NULL) OR ([otros] = @Original_otros)) AND ((@IsNull_pasante = 1 AND [pasante] IS NULL) OR ([pasante] = @Original_pasante)) AND ((@IsNull_trunco = 1 AND [trunco] IS NULL) OR ([trunco] = @Original_trunco)) AND ((@IsNull_carrera = 1 AND [carrera] IS NULL) OR ([carrera] = @Original_carrera)) AND ((@IsNull_nombreescuela = 1 AND [nombreescuela] IS NULL) OR ([nombreescuela] = @Original_nombreescuela)) AND ((@IsNull_estudia = 1 AND [estudia] IS NULL) OR ([estudia] = @Original_estudia)) AND ((@IsNull_queestudia = 1 AND [queestudia] IS NULL) OR ([queestudia] = @Original_queestudia)) AND ((@IsNull_horario = 1 AND [horario] IS NULL) OR ([horario] = @Original_horario)) AND ((@IsNull_escuela = 1 AND [escuela] IS NULL) OR ([escuela] = @Original_escuela)) AND ((@IsNull_idioma = 1 AND [idioma] IS NULL) OR ([idioma] = @Original_idioma)) AND ((@IsNull_maquinasoficina = 1 AND [maquinasoficina] IS NULL) OR ([maquinasoficina] = @Original_maquinasoficina)) AND ((@IsNull_habilidadescomputacionales = 1 AND [habilidadescomputacionales] IS NULL) OR ([habilidadescomputacionales] = @Original_habilidadescomputacionales)) AND ((@IsNull_cursostomados = 1 AND [cursostomados] IS NULL) OR ([cursostomados] = @Original_cursostomados)) AND ((@IsNull_yatrabajoenpuesto = 1 AND [yatrabajoenpuesto] IS NULL) OR ([yatrabajoenpuesto] = @Original_yatrabajoenpuesto)) AND ((@IsNull_experiencia = 1 AND [experiencia] IS NULL) OR ([experiencia] = @Original_experiencia)) AND ((@IsNull_empresasimilar = 1 AND [empresasimilar] IS NULL) OR ([empresasimilar] = @Original_empresasimilar)) AND ((@IsNull_afiliadoimss = 1 AND [afiliadoimss] IS NULL) OR ([afiliadoimss] = @Original_afiliadoimss)) AND ((@IsNull_rfc = 1 AND [rfc] IS NULL) OR ([rfc] = @Original_rfc)) AND ((@IsNull_curp = 1 AND [curp] IS NULL) OR ([curp] = @Original_curp)) AND ((@IsNull_licencia = 1 AND [licencia] IS NULL) OR ([licencia] = @Original_licencia)) AND ((@IsNull_tipolicencia = 1 AND [tipolicencia] IS NULL) OR ([tipolicencia] = @Original_tipolicencia)) AND ((@IsNull_cartilla = 1 AND [cartilla] IS NULL) OR ([cartilla] = @Original_cartilla)) AND ((@IsNull_cartillanumero = 1 AND [cartillanumero] IS NULL) OR ([cartillanumero] = @Original_cartillanumero)) AND ((@IsNull_casapropia = 1 AND [casapropia] IS NULL) OR ([casapropia] = @Original_casapropia)) AND ((@IsNull_casarentada = 1 AND [casarentada] IS NULL) OR ([casarentada] = @Original_casarentada)) AND ((@IsNull_casaprestada = 1 AND [casaprestada] IS NULL) OR ([casaprestada] = @Original_casaprestada)) AND ((@IsNull_tiempoviviendo = 1 AND [tiempoviviendo] IS NULL) OR ([tiempoviviendo] = @Original_tiempoviviendo)) AND ((@IsNull_vivecon = 1 AND [vivecon] IS NULL) OR ([vivecon] = @Original_vivecon)) AND ((@IsNull_otroingreso = 1 AND [otroingreso] IS NULL) OR ([otroingreso] = @Original_otroingreso)) AND ((@IsNull_personasdependientes = 1 AND [personasdependientes] IS NULL) OR ([personasdependientes] = @Original_personasdependientes)) AND ((@IsNull_gastosmensuales = 1 AND [gastosmensuales] IS NULL) OR ([gastosmensuales] = @Original_gastosmensuales)) AND ((@IsNull_aportacionhogar = 1 AND [aportacionhogar] IS NULL) OR ([aportacionhogar] = @Original_aportacionhogar)) AND ((@IsNull_automovilpropio = 1 AND [automovilpropio] IS NULL) OR ([automovilpropio] = @Original_automovilpropio)) AND ((@IsNull_modeloauto = 1 AND [modeloauto] IS NULL) OR ([modeloauto] = @Original_modeloauto)) AND ((@IsNull_tienecredito = 1 AND [tienecredito] IS NULL) OR ([tienecredito] = @Original_tienecredito)) AND ((@IsNull_deudas = 1 AND [deudas] IS NULL) OR ([deudas] = @Original_deudas)) AND ((@IsNull_abonomensual = 1 AND [abonomensual] IS NULL) OR ([abonomensual] = @Original_abonomensual)) AND ((@IsNull_salud = 1 AND [salud] IS NULL) OR ([salud] = @Original_salud)) AND ((@IsNull_enfermedadcronica = 1 AND [enfermedadcronica] IS NULL) OR ([enfermedadcronica] = @Original_enfermedadcronica)) AND ((@IsNull_cualcronica = 1 AND [cualcronica] IS NULL) OR ([cualcronica] = @Original_cualcronica)) AND ((@IsNull_enfermedadqueimpida = 1 AND [enfermedadqueimpida] IS NULL) OR ([enfermedadqueimpida] = @Original_enfermedadqueimpida)) AND ((@IsNull_cualimpida = 1 AND [cualimpida] IS NULL) OR ([cualimpida] = @Original_cualimpida)) AND ((@IsNull_enfermedadcontagiosa = 1 AND [enfermedadcontagiosa] IS NULL) OR ([enfermedadcontagiosa] = @Original_enfermedadcontagiosa)) AND ((@IsNull_cualcontagiosa = 1 AND [cualcontagiosa] IS NULL) OR ([cualcontagiosa] = @Original_cualcontagiosa)) AND ((@IsNull_cuantasincapacidades = 1 AND [cuantasincapacidades] IS NULL) OR ([cuantasincapacidades] = @Original_cuantasincapacidades)) AND ((@IsNull_motivoincapacidad = 1 AND [motivoincapacidad] IS NULL) OR ([motivoincapacidad] = @Original_motivoincapacidad)) AND ((@IsNull_consumirdroga = 1 AND [consumirdroga] IS NULL) OR ([consumirdroga] = @Original_consumirdroga)) AND ((@IsNull_tipodroga = 1 AND [tipodroga] IS NULL) OR ([tipodroga] = @Original_tipodroga)) AND ((@IsNull_fuma = 1 AND [fuma] IS NULL) OR ([fuma] = @Original_fuma)) AND ((@IsNull_tomaalcohol = 1 AND [tomaalcohol] IS NULL) OR ([tomaalcohol] = @Original_tomaalcohol)) AND ((@IsNull_metacorto = 1 AND [metacorto] IS NULL) OR ([metacorto] = @Original_metacorto)) AND ((@IsNull_metamediando = 1 AND [metamediando] IS NULL) OR ([metamediando] = @Original_metamediando)) AND ((@IsNull_metalargo = 1 AND [metalargo] IS NULL) OR ([metalargo] = @Original_metalargo)) AND ((@IsNull_examenesdroga = 1 AND [examenesdroga] IS NULL) OR ([examenesdroga] = @Original_examenesdroga)) AND ((@IsNull_comentarios = 1 AND [comentarios] IS NULL) OR ([comentarios] = @Original_comentarios)) AND ((@IsNull_casapadres = 1 AND [casapadres] IS NULL) OR ([casapadres] = @Original_casapadres)) AND ((@IsNull_cualotradroga = 1 AND [cualotradroga] IS NULL) OR ([cualotradroga] = @Original_cualotradroga)) AND ((@IsNull_salariodeseado = 1 AND [salariodeseado] IS NULL) OR ([salariodeseado] = @Original_salariodeseado)) AND ((@IsNull_disponibilidadhorario = 1 AND [disponibilidadhorario] IS NULL) OR ([disponibilidadhorario] = @Original_disponibilidadhorario)) AND ((@IsNull_disponibilidadviajar = 1 AND [disponibilidadviajar] IS NULL) OR ([disponibilidadviajar] = @Original_disponibilidadviajar)));
SELECT idcandidato, identrecosea, idusuario, fecha, estadocivil, hijos, valores, descripcion, defectos, primaria, secundaria, tecnico, comercial, titulado, preparatoria, profesional, maestria, otros, pasante, trunco, carrera, nombreescuela, estudia, queestudia, horario, escuela, idioma, maquinasoficina, habilidadescomputacionales, cursostomados, yatrabajoenpuesto, experiencia, empresasimilar, afiliadoimss, rfc, curp, licencia, tipolicencia, cartilla, cartillanumero, casapropia, casarentada, casaprestada, tiempoviviendo, vivecon, otroingreso, personasdependientes, gastosmensuales, aportacionhogar, automovilpropio, modeloauto, tienecredito, deudas, abonomensual, salud, enfermedadcronica, cualcronica, enfermedadqueimpida, cualimpida, enfermedadcontagiosa, cualcontagiosa, cuantasincapacidades, motivoincapacidad, consumirdroga, tipodroga, fuma, tomaalcohol, metacorto, metamediando, metalargo, examenesdroga, comentarios, casapadres, cualotradroga, salariodeseado, disponibilidadhorario, disponibilidadviajar FROM EntrevistaCosea WHERE (identrecosea = @identrecosea)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@idcandidato" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="idcandidato" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@identrecosea" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="identrecosea" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@idusuario" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="idusuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@fecha" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@estadocivil" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="estadocivil" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@hijos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hijos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@valores" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="valores" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@descripcion" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@defectos" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="defectos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@primaria" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="primaria" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@secundaria" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="secundaria" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@tecnico" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="tecnico" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@comercial" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="comercial" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@titulado" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="titulado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@preparatoria" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="preparatoria" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@profesional" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="profesional" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@maestria" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="maestria" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@otros" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="otros" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@pasante" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="pasante" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@trunco" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="trunco" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@carrera" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="carrera" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@nombreescuela" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="nombreescuela" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@estudia" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="estudia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@queestudia" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="queestudia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@horario" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="horario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@escuela" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="escuela" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@idioma" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="idioma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@maquinasoficina" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="maquinasoficina" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@habilidadescomputacionales" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="habilidadescomputacionales" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@cursostomados" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cursostomados" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@yatrabajoenpuesto" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="yatrabajoenpuesto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@experiencia" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="experiencia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@empresasimilar" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="empresasimilar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@afiliadoimss" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="afiliadoimss" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@rfc" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="rfc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@curp" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="curp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@licencia" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="licencia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@tipolicencia" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="tipolicencia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@cartilla" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cartilla" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@cartillanumero" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cartillanumero" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@casapropia" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="casapropia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@casarentada" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="casarentada" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@casaprestada" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="casaprestada" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@tiempoviviendo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tiempoviviendo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@vivecon" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="vivecon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@otroingreso" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="otroingreso" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@personasdependientes" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="personasdependientes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@gastosmensuales" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="gastosmensuales" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@aportacionhogar" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="aportacionhogar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@automovilpropio" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="automovilpropio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@modeloauto" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="modeloauto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@tienecredito" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="tienecredito" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@deudas" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="deudas" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@abonomensual" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="abonomensual" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@salud" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="salud" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@enfermedadcronica" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="enfermedadcronica" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@cualcronica" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cualcronica" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@enfermedadqueimpida" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="enfermedadqueimpida" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@cualimpida" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cualimpida" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@enfermedadcontagiosa" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="enfermedadcontagiosa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@cualcontagiosa" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cualcontagiosa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@cuantasincapacidades" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cuantasincapacidades" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@motivoincapacidad" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="motivoincapacidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@consumirdroga" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="consumirdroga" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@tipodroga" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="tipodroga" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@fuma" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="fuma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@tomaalcohol" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="tomaalcohol" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@metacorto" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="metacorto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@metamediando" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="metamediando" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@metalargo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="metalargo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@examenesdroga" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="examenesdroga" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@comentarios" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="comentarios" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@casapadres" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="casapadres" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@cualotradroga" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cualotradroga" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@salariodeseado" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="salariodeseado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@disponibilidadhorario" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="disponibilidadhorario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@disponibilidadviajar" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="disponibilidadviajar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_idcandidato" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="idcandidato" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_identrecosea" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="identrecosea" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_idusuario" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="idusuario" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fecha" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_fecha" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_estadocivil" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="estadocivil" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_estadocivil" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="estadocivil" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hijos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hijos" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_hijos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hijos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_valores" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="valores" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_valores" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="valores" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_descripcion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_descripcion" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_defectos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="defectos" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_defectos" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="defectos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_primaria" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="primaria" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_primaria" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="primaria" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_secundaria" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="secundaria" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_secundaria" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="secundaria" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tecnico" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tecnico" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_tecnico" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="tecnico" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_comercial" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="comercial" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_comercial" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="comercial" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_titulado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="titulado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_titulado" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="titulado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_preparatoria" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="preparatoria" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_preparatoria" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="preparatoria" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_profesional" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="profesional" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_profesional" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="profesional" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maestria" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maestria" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_maestria" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="maestria" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_otros" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="otros" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_otros" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="otros" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pasante" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pasante" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_pasante" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="pasante" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_trunco" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="trunco" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_trunco" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="trunco" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_carrera" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="carrera" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_carrera" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="carrera" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nombreescuela" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nombreescuela" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_nombreescuela" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="nombreescuela" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_estudia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="estudia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_estudia" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="estudia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_queestudia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="queestudia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_queestudia" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="queestudia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_horario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="horario" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_horario" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="horario" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_escuela" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="escuela" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_escuela" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="escuela" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idioma" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idioma" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_idioma" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="idioma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maquinasoficina" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maquinasoficina" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_maquinasoficina" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="maquinasoficina" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_habilidadescomputacionales" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="habilidadescomputacionales" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_habilidadescomputacionales" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="habilidadescomputacionales" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cursostomados" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cursostomados" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_cursostomados" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cursostomados" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_yatrabajoenpuesto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="yatrabajoenpuesto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_yatrabajoenpuesto" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="yatrabajoenpuesto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_experiencia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="experiencia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_experiencia" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="experiencia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_empresasimilar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="empresasimilar" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_empresasimilar" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="empresasimilar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_afiliadoimss" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="afiliadoimss" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_afiliadoimss" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="afiliadoimss" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_rfc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="rfc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_rfc" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="rfc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_curp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="curp" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_curp" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="curp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_licencia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="licencia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_licencia" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="licencia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tipolicencia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tipolicencia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_tipolicencia" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="tipolicencia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cartilla" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cartilla" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_cartilla" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cartilla" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cartillanumero" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cartillanumero" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_cartillanumero" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cartillanumero" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_casapropia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="casapropia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_casapropia" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="casapropia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_casarentada" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="casarentada" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_casarentada" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="casarentada" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_casaprestada" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="casaprestada" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_casaprestada" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="casaprestada" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tiempoviviendo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tiempoviviendo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_tiempoviviendo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tiempoviviendo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_vivecon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="vivecon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_vivecon" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="vivecon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_otroingreso" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="otroingreso" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_otroingreso" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="otroingreso" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_personasdependientes" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="personasdependientes" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_personasdependientes" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="personasdependientes" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_gastosmensuales" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gastosmensuales" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_gastosmensuales" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="gastosmensuales" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_aportacionhogar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="aportacionhogar" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_aportacionhogar" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="aportacionhogar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_automovilpropio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="automovilpropio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_automovilpropio" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="automovilpropio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_modeloauto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="modeloauto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_modeloauto" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="modeloauto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tienecredito" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tienecredito" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_tienecredito" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="tienecredito" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_deudas" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deudas" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_deudas" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="deudas" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_abonomensual" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="abonomensual" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_abonomensual" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="abonomensual" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_salud" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="salud" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_salud" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="salud" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_enfermedadcronica" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="enfermedadcronica" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_enfermedadcronica" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="enfermedadcronica" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cualcronica" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cualcronica" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_cualcronica" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cualcronica" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_enfermedadqueimpida" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="enfermedadqueimpida" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_enfermedadqueimpida" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="enfermedadqueimpida" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cualimpida" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cualimpida" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_cualimpida" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cualimpida" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_enfermedadcontagiosa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="enfermedadcontagiosa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_enfermedadcontagiosa" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="enfermedadcontagiosa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cualcontagiosa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cualcontagiosa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_cualcontagiosa" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cualcontagiosa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cuantasincapacidades" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cuantasincapacidades" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_cuantasincapacidades" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cuantasincapacidades" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_motivoincapacidad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="motivoincapacidad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_motivoincapacidad" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="motivoincapacidad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_consumirdroga" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="consumirdroga" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_consumirdroga" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="consumirdroga" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tipodroga" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tipodroga" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_tipodroga" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="tipodroga" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fuma" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fuma" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_fuma" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="fuma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tomaalcohol" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tomaalcohol" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_tomaalcohol" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="tomaalcohol" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_metacorto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="metacorto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_metacorto" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="metacorto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_metamediando" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="metamediando" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_metamediando" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="metamediando" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_metalargo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="metalargo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_metalargo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="metalargo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_examenesdroga" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="examenesdroga" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_examenesdroga" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="examenesdroga" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_comentarios" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="comentarios" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_comentarios" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="comentarios" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_casapadres" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="casapadres" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_casapadres" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="casapadres" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cualotradroga" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cualotradroga" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_cualotradroga" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cualotradroga" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_salariodeseado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="salariodeseado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_salariodeseado" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="salariodeseado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_disponibilidadhorario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="disponibilidadhorario" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_disponibilidadhorario" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="disponibilidadhorario" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_disponibilidadviajar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="disponibilidadviajar" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_disponibilidadviajar" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="disponibilidadviajar" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idcandidato" DataSetColumn="idcandidato" />
              <Mapping SourceColumn="identrecosea" DataSetColumn="identrecosea" />
              <Mapping SourceColumn="idusuario" DataSetColumn="idusuario" />
              <Mapping SourceColumn="fecha" DataSetColumn="fecha" />
              <Mapping SourceColumn="estadocivil" DataSetColumn="estadocivil" />
              <Mapping SourceColumn="hijos" DataSetColumn="hijos" />
              <Mapping SourceColumn="valores" DataSetColumn="valores" />
              <Mapping SourceColumn="descripcion" DataSetColumn="descripcion" />
              <Mapping SourceColumn="defectos" DataSetColumn="defectos" />
              <Mapping SourceColumn="primaria" DataSetColumn="primaria" />
              <Mapping SourceColumn="secundaria" DataSetColumn="secundaria" />
              <Mapping SourceColumn="tecnico" DataSetColumn="tecnico" />
              <Mapping SourceColumn="comercial" DataSetColumn="comercial" />
              <Mapping SourceColumn="titulado" DataSetColumn="titulado" />
              <Mapping SourceColumn="preparatoria" DataSetColumn="preparatoria" />
              <Mapping SourceColumn="profesional" DataSetColumn="profesional" />
              <Mapping SourceColumn="maestria" DataSetColumn="maestria" />
              <Mapping SourceColumn="otros" DataSetColumn="otros" />
              <Mapping SourceColumn="pasante" DataSetColumn="pasante" />
              <Mapping SourceColumn="trunco" DataSetColumn="trunco" />
              <Mapping SourceColumn="carrera" DataSetColumn="carrera" />
              <Mapping SourceColumn="nombreescuela" DataSetColumn="nombreescuela" />
              <Mapping SourceColumn="estudia" DataSetColumn="estudia" />
              <Mapping SourceColumn="queestudia" DataSetColumn="queestudia" />
              <Mapping SourceColumn="horario" DataSetColumn="horario" />
              <Mapping SourceColumn="escuela" DataSetColumn="escuela" />
              <Mapping SourceColumn="idioma" DataSetColumn="idioma" />
              <Mapping SourceColumn="maquinasoficina" DataSetColumn="maquinasoficina" />
              <Mapping SourceColumn="habilidadescomputacionales" DataSetColumn="habilidadescomputacionales" />
              <Mapping SourceColumn="cursostomados" DataSetColumn="cursostomados" />
              <Mapping SourceColumn="yatrabajoenpuesto" DataSetColumn="yatrabajoenpuesto" />
              <Mapping SourceColumn="experiencia" DataSetColumn="experiencia" />
              <Mapping SourceColumn="empresasimilar" DataSetColumn="empresasimilar" />
              <Mapping SourceColumn="afiliadoimss" DataSetColumn="afiliadoimss" />
              <Mapping SourceColumn="rfc" DataSetColumn="rfc" />
              <Mapping SourceColumn="curp" DataSetColumn="curp" />
              <Mapping SourceColumn="licencia" DataSetColumn="licencia" />
              <Mapping SourceColumn="tipolicencia" DataSetColumn="tipolicencia" />
              <Mapping SourceColumn="cartilla" DataSetColumn="cartilla" />
              <Mapping SourceColumn="cartillanumero" DataSetColumn="cartillanumero" />
              <Mapping SourceColumn="casapropia" DataSetColumn="casapropia" />
              <Mapping SourceColumn="casarentada" DataSetColumn="casarentada" />
              <Mapping SourceColumn="casaprestada" DataSetColumn="casaprestada" />
              <Mapping SourceColumn="tiempoviviendo" DataSetColumn="tiempoviviendo" />
              <Mapping SourceColumn="vivecon" DataSetColumn="vivecon" />
              <Mapping SourceColumn="otroingreso" DataSetColumn="otroingreso" />
              <Mapping SourceColumn="personasdependientes" DataSetColumn="personasdependientes" />
              <Mapping SourceColumn="gastosmensuales" DataSetColumn="gastosmensuales" />
              <Mapping SourceColumn="aportacionhogar" DataSetColumn="aportacionhogar" />
              <Mapping SourceColumn="automovilpropio" DataSetColumn="automovilpropio" />
              <Mapping SourceColumn="modeloauto" DataSetColumn="modeloauto" />
              <Mapping SourceColumn="tienecredito" DataSetColumn="tienecredito" />
              <Mapping SourceColumn="deudas" DataSetColumn="deudas" />
              <Mapping SourceColumn="abonomensual" DataSetColumn="abonomensual" />
              <Mapping SourceColumn="salud" DataSetColumn="salud" />
              <Mapping SourceColumn="enfermedadcronica" DataSetColumn="enfermedadcronica" />
              <Mapping SourceColumn="cualcronica" DataSetColumn="cualcronica" />
              <Mapping SourceColumn="enfermedadqueimpida" DataSetColumn="enfermedadqueimpida" />
              <Mapping SourceColumn="cualimpida" DataSetColumn="cualimpida" />
              <Mapping SourceColumn="enfermedadcontagiosa" DataSetColumn="enfermedadcontagiosa" />
              <Mapping SourceColumn="cualcontagiosa" DataSetColumn="cualcontagiosa" />
              <Mapping SourceColumn="cuantasincapacidades" DataSetColumn="cuantasincapacidades" />
              <Mapping SourceColumn="motivoincapacidad" DataSetColumn="motivoincapacidad" />
              <Mapping SourceColumn="consumirdroga" DataSetColumn="consumirdroga" />
              <Mapping SourceColumn="tipodroga" DataSetColumn="tipodroga" />
              <Mapping SourceColumn="fuma" DataSetColumn="fuma" />
              <Mapping SourceColumn="tomaalcohol" DataSetColumn="tomaalcohol" />
              <Mapping SourceColumn="metacorto" DataSetColumn="metacorto" />
              <Mapping SourceColumn="metamediando" DataSetColumn="metamediando" />
              <Mapping SourceColumn="metalargo" DataSetColumn="metalargo" />
              <Mapping SourceColumn="examenesdroga" DataSetColumn="examenesdroga" />
              <Mapping SourceColumn="comentarios" DataSetColumn="comentarios" />
              <Mapping SourceColumn="casapadres" DataSetColumn="casapadres" />
              <Mapping SourceColumn="cualotradroga" DataSetColumn="cualotradroga" />
              <Mapping SourceColumn="salariodeseado" DataSetColumn="salariodeseado" />
              <Mapping SourceColumn="disponibilidadhorario" DataSetColumn="disponibilidadhorario" />
              <Mapping SourceColumn="disponibilidadviajar" DataSetColumn="disponibilidadviajar" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PersonaTableAdapter" GeneratorDataComponentClassName="PersonaTableAdapter" Name="Persona" UserDataComponentName="PersonaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Cosea_ReclutamientoConnectionString (Settings)" DbObjectName="Cosea_Reclutamiento.dbo.Persona" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Persona] WHERE (([idpersona] = @Original_idpersona) AND ((@IsNull_nombre1 = 1 AND [nombre1] IS NULL) OR ([nombre1] = @Original_nombre1)) AND ((@IsNull_nombre2 = 1 AND [nombre2] IS NULL) OR ([nombre2] = @Original_nombre2)) AND ((@IsNull_apellido1 = 1 AND [apellido1] IS NULL) OR ([apellido1] = @Original_apellido1)) AND ((@IsNull_apellido2 = 1 AND [apellido2] IS NULL) OR ([apellido2] = @Original_apellido2)) AND ((@IsNull_calle = 1 AND [calle] IS NULL) OR ([calle] = @Original_calle)) AND ((@IsNull_colonia = 1 AND [colonia] IS NULL) OR ([colonia] = @Original_colonia)) AND ((@IsNull_municipio = 1 AND [municipio] IS NULL) OR ([municipio] = @Original_municipio)) AND ((@IsNull_cp = 1 AND [cp] IS NULL) OR ([cp] = @Original_cp)) AND ((@IsNull_telefono1 = 1 AND [telefono1] IS NULL) OR ([telefono1] = @Original_telefono1)) AND ((@IsNull_telefono2 = 1 AND [telefono2] IS NULL) OR ([telefono2] = @Original_telefono2)) AND ((@IsNull_celular1 = 1 AND [celular1] IS NULL) OR ([celular1] = @Original_celular1)) AND ((@IsNull_celular2 = 1 AND [celular2] IS NULL) OR ([celular2] = @Original_celular2)) AND ((@IsNull_fechaalta = 1 AND [fechaalta] IS NULL) OR ([fechaalta] = @Original_fechaalta)) AND ((@IsNull_fechanacimiento = 1 AND [fechanacimiento] IS NULL) OR ([fechanacimiento] = @Original_fechanacimiento)) AND ((@IsNull_ciudadnacimiento = 1 AND [ciudadnacimiento] IS NULL) OR ([ciudadnacimiento] = @Original_ciudadnacimiento)) AND ((@IsNull_paisnacimiento = 1 AND [paisnacimiento] IS NULL) OR ([paisnacimiento] = @Original_paisnacimiento)) AND ((@IsNull_comentarios = 1 AND [comentarios] IS NULL) OR ([comentarios] = @Original_comentarios)) AND ((@IsNull_activo = 1 AND [activo] IS NULL) OR ([activo] = @Original_activo)) AND ((@IsNull_email = 1 AND [email] IS NULL) OR ([email] = @Original_email)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_idpersona" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="idpersona" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nombre1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nombre1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_nombre1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="nombre1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nombre2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nombre2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_nombre2" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="nombre2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_apellido1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="apellido1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_apellido1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="apellido1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_apellido2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="apellido2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_apellido2" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="apellido2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_calle" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="calle" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_calle" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="calle" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_colonia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="colonia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_colonia" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="colonia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_municipio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="municipio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_municipio" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="municipio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cp" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_cp" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_telefono1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="telefono1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_telefono1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="telefono1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_telefono2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="telefono2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_telefono2" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="telefono2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_celular1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="celular1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_celular1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="celular1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_celular2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="celular2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_celular2" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="celular2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fechaalta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fechaalta" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_fechaalta" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="fechaalta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fechanacimiento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fechanacimiento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_fechanacimiento" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="fechanacimiento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ciudadnacimiento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ciudadnacimiento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ciudadnacimiento" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ciudadnacimiento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_paisnacimiento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="paisnacimiento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_paisnacimiento" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="paisnacimiento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_comentarios" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="comentarios" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_comentarios" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="comentarios" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_activo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="activo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_activo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="activo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_email" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Persona] ([idpersona], [nombre1], [nombre2], [apellido1], [apellido2], [calle], [colonia], [municipio], [cp], [telefono1], [telefono2], [celular1], [celular2], [fechaalta], [fechanacimiento], [ciudadnacimiento], [paisnacimiento], [comentarios], [activo], [email]) VALUES (@idpersona, @nombre1, @nombre2, @apellido1, @apellido2, @calle, @colonia, @municipio, @cp, @telefono1, @telefono2, @celular1, @celular2, @fechaalta, @fechanacimiento, @ciudadnacimiento, @paisnacimiento, @comentarios, @activo, @email);
SELECT idpersona, nombre1, nombre2, apellido1, apellido2, calle, colonia, municipio, cp, telefono1, telefono2, celular1, celular2, fechaalta, fechanacimiento, ciudadnacimiento, paisnacimiento, comentarios, activo, email FROM Persona WHERE (idpersona = @idpersona)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@idpersona" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="idpersona" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@nombre1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="nombre1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@nombre2" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="nombre2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@apellido1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="apellido1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@apellido2" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="apellido2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@calle" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="calle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@colonia" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="colonia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@municipio" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="municipio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@cp" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@telefono1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="telefono1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@telefono2" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="telefono2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@celular1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="celular1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@celular2" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="celular2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@fechaalta" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="fechaalta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@fechanacimiento" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="fechanacimiento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ciudadnacimiento" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ciudadnacimiento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@paisnacimiento" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="paisnacimiento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@comentarios" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="comentarios" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@activo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="activo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idpersona, nombre1, nombre2, apellido1, apellido2, calle, colonia, municipio, cp, telefono1, telefono2, celular1, celular2, fechaalta, fechanacimiento, ciudadnacimiento, paisnacimiento, comentarios, activo, email FROM dbo.Persona</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Persona] SET [idpersona] = @idpersona, [nombre1] = @nombre1, [nombre2] = @nombre2, [apellido1] = @apellido1, [apellido2] = @apellido2, [calle] = @calle, [colonia] = @colonia, [municipio] = @municipio, [cp] = @cp, [telefono1] = @telefono1, [telefono2] = @telefono2, [celular1] = @celular1, [celular2] = @celular2, [fechaalta] = @fechaalta, [fechanacimiento] = @fechanacimiento, [ciudadnacimiento] = @ciudadnacimiento, [paisnacimiento] = @paisnacimiento, [comentarios] = @comentarios, [activo] = @activo, [email] = @email WHERE (([idpersona] = @Original_idpersona) AND ((@IsNull_nombre1 = 1 AND [nombre1] IS NULL) OR ([nombre1] = @Original_nombre1)) AND ((@IsNull_nombre2 = 1 AND [nombre2] IS NULL) OR ([nombre2] = @Original_nombre2)) AND ((@IsNull_apellido1 = 1 AND [apellido1] IS NULL) OR ([apellido1] = @Original_apellido1)) AND ((@IsNull_apellido2 = 1 AND [apellido2] IS NULL) OR ([apellido2] = @Original_apellido2)) AND ((@IsNull_calle = 1 AND [calle] IS NULL) OR ([calle] = @Original_calle)) AND ((@IsNull_colonia = 1 AND [colonia] IS NULL) OR ([colonia] = @Original_colonia)) AND ((@IsNull_municipio = 1 AND [municipio] IS NULL) OR ([municipio] = @Original_municipio)) AND ((@IsNull_cp = 1 AND [cp] IS NULL) OR ([cp] = @Original_cp)) AND ((@IsNull_telefono1 = 1 AND [telefono1] IS NULL) OR ([telefono1] = @Original_telefono1)) AND ((@IsNull_telefono2 = 1 AND [telefono2] IS NULL) OR ([telefono2] = @Original_telefono2)) AND ((@IsNull_celular1 = 1 AND [celular1] IS NULL) OR ([celular1] = @Original_celular1)) AND ((@IsNull_celular2 = 1 AND [celular2] IS NULL) OR ([celular2] = @Original_celular2)) AND ((@IsNull_fechaalta = 1 AND [fechaalta] IS NULL) OR ([fechaalta] = @Original_fechaalta)) AND ((@IsNull_fechanacimiento = 1 AND [fechanacimiento] IS NULL) OR ([fechanacimiento] = @Original_fechanacimiento)) AND ((@IsNull_ciudadnacimiento = 1 AND [ciudadnacimiento] IS NULL) OR ([ciudadnacimiento] = @Original_ciudadnacimiento)) AND ((@IsNull_paisnacimiento = 1 AND [paisnacimiento] IS NULL) OR ([paisnacimiento] = @Original_paisnacimiento)) AND ((@IsNull_comentarios = 1 AND [comentarios] IS NULL) OR ([comentarios] = @Original_comentarios)) AND ((@IsNull_activo = 1 AND [activo] IS NULL) OR ([activo] = @Original_activo)) AND ((@IsNull_email = 1 AND [email] IS NULL) OR ([email] = @Original_email)));
SELECT idpersona, nombre1, nombre2, apellido1, apellido2, calle, colonia, municipio, cp, telefono1, telefono2, celular1, celular2, fechaalta, fechanacimiento, ciudadnacimiento, paisnacimiento, comentarios, activo, email FROM Persona WHERE (idpersona = @idpersona)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@idpersona" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="idpersona" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@nombre1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="nombre1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@nombre2" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="nombre2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@apellido1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="apellido1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@apellido2" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="apellido2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@calle" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="calle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@colonia" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="colonia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@municipio" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="municipio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@cp" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@telefono1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="telefono1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@telefono2" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="telefono2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@celular1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="celular1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@celular2" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="celular2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@fechaalta" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="fechaalta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@fechanacimiento" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="fechanacimiento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ciudadnacimiento" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ciudadnacimiento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@paisnacimiento" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="paisnacimiento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@comentarios" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="comentarios" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@activo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="activo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_idpersona" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="idpersona" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nombre1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nombre1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_nombre1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="nombre1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nombre2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nombre2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_nombre2" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="nombre2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_apellido1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="apellido1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_apellido1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="apellido1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_apellido2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="apellido2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_apellido2" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="apellido2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_calle" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="calle" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_calle" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="calle" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_colonia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="colonia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_colonia" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="colonia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_municipio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="municipio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_municipio" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="municipio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cp" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_cp" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="cp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_telefono1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="telefono1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_telefono1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="telefono1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_telefono2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="telefono2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_telefono2" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="telefono2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_celular1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="celular1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_celular1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="celular1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_celular2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="celular2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_celular2" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="celular2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fechaalta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fechaalta" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_fechaalta" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="fechaalta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fechanacimiento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fechanacimiento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_fechanacimiento" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="fechanacimiento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ciudadnacimiento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ciudadnacimiento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ciudadnacimiento" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ciudadnacimiento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_paisnacimiento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="paisnacimiento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_paisnacimiento" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="paisnacimiento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_comentarios" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="comentarios" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_comentarios" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="comentarios" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_activo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="activo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_activo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="activo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_email" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idpersona" DataSetColumn="idpersona" />
              <Mapping SourceColumn="nombre1" DataSetColumn="nombre1" />
              <Mapping SourceColumn="nombre2" DataSetColumn="nombre2" />
              <Mapping SourceColumn="apellido1" DataSetColumn="apellido1" />
              <Mapping SourceColumn="apellido2" DataSetColumn="apellido2" />
              <Mapping SourceColumn="calle" DataSetColumn="calle" />
              <Mapping SourceColumn="colonia" DataSetColumn="colonia" />
              <Mapping SourceColumn="municipio" DataSetColumn="municipio" />
              <Mapping SourceColumn="cp" DataSetColumn="cp" />
              <Mapping SourceColumn="telefono1" DataSetColumn="telefono1" />
              <Mapping SourceColumn="telefono2" DataSetColumn="telefono2" />
              <Mapping SourceColumn="celular1" DataSetColumn="celular1" />
              <Mapping SourceColumn="celular2" DataSetColumn="celular2" />
              <Mapping SourceColumn="fechaalta" DataSetColumn="fechaalta" />
              <Mapping SourceColumn="fechanacimiento" DataSetColumn="fechanacimiento" />
              <Mapping SourceColumn="ciudadnacimiento" DataSetColumn="ciudadnacimiento" />
              <Mapping SourceColumn="paisnacimiento" DataSetColumn="paisnacimiento" />
              <Mapping SourceColumn="comentarios" DataSetColumn="comentarios" />
              <Mapping SourceColumn="activo" DataSetColumn="activo" />
              <Mapping SourceColumn="email" DataSetColumn="email" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="Cosea_ReclutamientoDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="Cosea_ReclutamientoDataSet" msprop:Generator_UserDSName="Cosea_ReclutamientoDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Candidato" msprop:Generator_TableClassName="CandidatoDataTable" msprop:Generator_TableVarName="tableCandidato" msprop:Generator_TablePropName="Candidato" msprop:Generator_RowDeletingName="CandidatoRowDeleting" msprop:Generator_UserTableName="Candidato" msprop:Generator_RowChangingName="CandidatoRowChanging" msprop:Generator_RowEvHandlerName="CandidatoRowChangeEventHandler" msprop:Generator_RowDeletedName="CandidatoRowDeleted" msprop:Generator_RowEvArgName="CandidatoRowChangeEvent" msprop:Generator_RowChangedName="CandidatoRowChanged" msprop:Generator_RowClassName="CandidatoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idcandidato" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnidcandidato" msprop:Generator_ColumnPropNameInRow="idcandidato" msprop:Generator_ColumnPropNameInTable="idcandidatoColumn" msprop:Generator_UserColumnName="idcandidato" type="xs:string" />
              <xs:element name="idpersona" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnidpersona" msprop:Generator_ColumnPropNameInRow="idpersona" msprop:Generator_ColumnPropNameInTable="idpersonaColumn" msprop:Generator_UserColumnName="idpersona" type="xs:string" />
              <xs:element name="activo" msprop:Generator_ColumnVarNameInTable="columnactivo" msprop:Generator_ColumnPropNameInRow="activo" msprop:Generator_ColumnPropNameInTable="activoColumn" msprop:Generator_UserColumnName="activo" type="xs:boolean" minOccurs="0" />
              <xs:element name="fechaalta" msprop:Generator_ColumnVarNameInTable="columnfechaalta" msprop:Generator_ColumnPropNameInRow="fechaalta" msprop:Generator_ColumnPropNameInTable="fechaaltaColumn" msprop:Generator_UserColumnName="fechaalta" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Curriculum" msprop:Generator_TableClassName="CurriculumDataTable" msprop:Generator_TableVarName="tableCurriculum" msprop:Generator_TablePropName="Curriculum" msprop:Generator_RowDeletingName="CurriculumRowDeleting" msprop:Generator_UserTableName="Curriculum" msprop:Generator_RowChangingName="CurriculumRowChanging" msprop:Generator_RowEvHandlerName="CurriculumRowChangeEventHandler" msprop:Generator_RowDeletedName="CurriculumRowDeleted" msprop:Generator_RowEvArgName="CurriculumRowChangeEvent" msprop:Generator_RowChangedName="CurriculumRowChanged" msprop:Generator_RowClassName="CurriculumRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idcurriculum" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnidcurriculum" msprop:Generator_ColumnPropNameInRow="idcurriculum" msprop:Generator_ColumnPropNameInTable="idcurriculumColumn" msprop:Generator_UserColumnName="idcurriculum" type="xs:string" />
              <xs:element name="idcandidato" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnidcandidato" msprop:Generator_ColumnPropNameInRow="idcandidato" msprop:Generator_ColumnPropNameInTable="idcandidatoColumn" msprop:Generator_UserColumnName="idcandidato" type="xs:string" />
              <xs:element name="nombrecompleto" msprop:Generator_ColumnVarNameInTable="columnnombrecompleto" msprop:Generator_ColumnPropNameInRow="nombrecompleto" msprop:Generator_ColumnPropNameInTable="nombrecompletoColumn" msprop:Generator_UserColumnName="nombrecompleto" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="60" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="expectativasprofesionales" msprop:Generator_ColumnVarNameInTable="columnexpectativasprofesionales" msprop:Generator_ColumnPropNameInRow="expectativasprofesionales" msprop:Generator_ColumnPropNameInTable="expectativasprofesionalesColumn" msprop:Generator_UserColumnName="expectativasprofesionales" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="estudiosrealizados" msprop:Generator_ColumnVarNameInTable="columnestudiosrealizados" msprop:Generator_ColumnPropNameInRow="estudiosrealizados" msprop:Generator_ColumnPropNameInTable="estudiosrealizadosColumn" msprop:Generator_UserColumnName="estudiosrealizados" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="experienciaprofesional" msprop:Generator_ColumnVarNameInTable="columnexperienciaprofesional" msprop:Generator_ColumnPropNameInRow="experienciaprofesional" msprop:Generator_ColumnPropNameInTable="experienciaprofesionalColumn" msprop:Generator_UserColumnName="experienciaprofesional" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="competencias" msprop:Generator_ColumnVarNameInTable="columncompetencias" msprop:Generator_ColumnPropNameInRow="competencias" msprop:Generator_ColumnPropNameInTable="competenciasColumn" msprop:Generator_UserColumnName="competencias" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="habilidades" msprop:Generator_ColumnVarNameInTable="columnhabilidades" msprop:Generator_ColumnPropNameInRow="habilidades" msprop:Generator_ColumnPropNameInTable="habilidadesColumn" msprop:Generator_UserColumnName="habilidades" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fechaalta" msprop:Generator_ColumnVarNameInTable="columnfechaalta" msprop:Generator_ColumnPropNameInRow="fechaalta" msprop:Generator_ColumnPropNameInTable="fechaaltaColumn" msprop:Generator_UserColumnName="fechaalta" type="xs:dateTime" minOccurs="0" />
              <xs:element name="activo" msprop:Generator_ColumnVarNameInTable="columnactivo" msprop:Generator_ColumnPropNameInRow="activo" msprop:Generator_ColumnPropNameInTable="activoColumn" msprop:Generator_UserColumnName="activo" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="EntrevistaCosea" msprop:Generator_TableClassName="EntrevistaCoseaDataTable" msprop:Generator_TableVarName="tableEntrevistaCosea" msprop:Generator_TablePropName="EntrevistaCosea" msprop:Generator_RowDeletingName="EntrevistaCoseaRowDeleting" msprop:Generator_UserTableName="EntrevistaCosea" msprop:Generator_RowChangingName="EntrevistaCoseaRowChanging" msprop:Generator_RowEvHandlerName="EntrevistaCoseaRowChangeEventHandler" msprop:Generator_RowDeletedName="EntrevistaCoseaRowDeleted" msprop:Generator_RowEvArgName="EntrevistaCoseaRowChangeEvent" msprop:Generator_RowChangedName="EntrevistaCoseaRowChanged" msprop:Generator_RowClassName="EntrevistaCoseaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idcandidato" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnidcandidato" msprop:Generator_ColumnPropNameInRow="idcandidato" msprop:Generator_ColumnPropNameInTable="idcandidatoColumn" msprop:Generator_UserColumnName="idcandidato" type="xs:string" />
              <xs:element name="identrecosea" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnidentrecosea" msprop:Generator_ColumnPropNameInRow="identrecosea" msprop:Generator_ColumnPropNameInTable="identrecoseaColumn" msprop:Generator_UserColumnName="identrecosea" type="xs:string" />
              <xs:element name="idusuario" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnidusuario" msprop:Generator_ColumnPropNameInRow="idusuario" msprop:Generator_ColumnPropNameInTable="idusuarioColumn" msprop:Generator_UserColumnName="idusuario" type="xs:string" />
              <xs:element name="fecha" msprop:Generator_ColumnVarNameInTable="columnfecha" msprop:Generator_ColumnPropNameInRow="fecha" msprop:Generator_ColumnPropNameInTable="fechaColumn" msprop:Generator_UserColumnName="fecha" type="xs:dateTime" minOccurs="0" />
              <xs:element name="estadocivil" msprop:Generator_ColumnVarNameInTable="columnestadocivil" msprop:Generator_ColumnPropNameInRow="estadocivil" msprop:Generator_ColumnPropNameInTable="estadocivilColumn" msprop:Generator_UserColumnName="estadocivil" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="hijos" msprop:Generator_ColumnVarNameInTable="columnhijos" msprop:Generator_ColumnPropNameInRow="hijos" msprop:Generator_ColumnPropNameInTable="hijosColumn" msprop:Generator_UserColumnName="hijos" type="xs:int" minOccurs="0" />
              <xs:element name="valores" msprop:Generator_ColumnVarNameInTable="columnvalores" msprop:Generator_ColumnPropNameInRow="valores" msprop:Generator_ColumnPropNameInTable="valoresColumn" msprop:Generator_UserColumnName="valores" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="descripcion" msprop:Generator_ColumnVarNameInTable="columndescripcion" msprop:Generator_ColumnPropNameInRow="descripcion" msprop:Generator_ColumnPropNameInTable="descripcionColumn" msprop:Generator_UserColumnName="descripcion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="defectos" msprop:Generator_ColumnVarNameInTable="columndefectos" msprop:Generator_ColumnPropNameInRow="defectos" msprop:Generator_ColumnPropNameInTable="defectosColumn" msprop:Generator_UserColumnName="defectos" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="primaria" msprop:Generator_ColumnVarNameInTable="columnprimaria" msprop:Generator_ColumnPropNameInRow="primaria" msprop:Generator_ColumnPropNameInTable="primariaColumn" msprop:Generator_UserColumnName="primaria" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="secundaria" msprop:Generator_ColumnVarNameInTable="columnsecundaria" msprop:Generator_ColumnPropNameInRow="secundaria" msprop:Generator_ColumnPropNameInTable="secundariaColumn" msprop:Generator_UserColumnName="secundaria" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tecnico" msprop:Generator_ColumnVarNameInTable="columntecnico" msprop:Generator_ColumnPropNameInRow="tecnico" msprop:Generator_ColumnPropNameInTable="tecnicoColumn" msprop:Generator_UserColumnName="tecnico" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="comercial" msprop:Generator_ColumnVarNameInTable="columncomercial" msprop:Generator_ColumnPropNameInRow="comercial" msprop:Generator_ColumnPropNameInTable="comercialColumn" msprop:Generator_UserColumnName="comercial" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="titulado" msprop:Generator_ColumnVarNameInTable="columntitulado" msprop:Generator_ColumnPropNameInRow="titulado" msprop:Generator_ColumnPropNameInTable="tituladoColumn" msprop:Generator_UserColumnName="titulado" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="preparatoria" msprop:Generator_ColumnVarNameInTable="columnpreparatoria" msprop:Generator_ColumnPropNameInRow="preparatoria" msprop:Generator_ColumnPropNameInTable="preparatoriaColumn" msprop:Generator_UserColumnName="preparatoria" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="profesional" msprop:Generator_ColumnVarNameInTable="columnprofesional" msprop:Generator_ColumnPropNameInRow="profesional" msprop:Generator_ColumnPropNameInTable="profesionalColumn" msprop:Generator_UserColumnName="profesional" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="maestria" msprop:Generator_ColumnVarNameInTable="columnmaestria" msprop:Generator_ColumnPropNameInRow="maestria" msprop:Generator_ColumnPropNameInTable="maestriaColumn" msprop:Generator_UserColumnName="maestria" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="otros" msprop:Generator_ColumnVarNameInTable="columnotros" msprop:Generator_ColumnPropNameInRow="otros" msprop:Generator_ColumnPropNameInTable="otrosColumn" msprop:Generator_UserColumnName="otros" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="pasante" msprop:Generator_ColumnVarNameInTable="columnpasante" msprop:Generator_ColumnPropNameInRow="pasante" msprop:Generator_ColumnPropNameInTable="pasanteColumn" msprop:Generator_UserColumnName="pasante" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="trunco" msprop:Generator_ColumnVarNameInTable="columntrunco" msprop:Generator_ColumnPropNameInRow="trunco" msprop:Generator_ColumnPropNameInTable="truncoColumn" msprop:Generator_UserColumnName="trunco" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="carrera" msprop:Generator_ColumnVarNameInTable="columncarrera" msprop:Generator_ColumnPropNameInRow="carrera" msprop:Generator_ColumnPropNameInTable="carreraColumn" msprop:Generator_UserColumnName="carrera" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nombreescuela" msprop:Generator_ColumnVarNameInTable="columnnombreescuela" msprop:Generator_ColumnPropNameInRow="nombreescuela" msprop:Generator_ColumnPropNameInTable="nombreescuelaColumn" msprop:Generator_UserColumnName="nombreescuela" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="estudia" msprop:Generator_ColumnVarNameInTable="columnestudia" msprop:Generator_ColumnPropNameInRow="estudia" msprop:Generator_ColumnPropNameInTable="estudiaColumn" msprop:Generator_UserColumnName="estudia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="queestudia" msprop:Generator_ColumnVarNameInTable="columnqueestudia" msprop:Generator_ColumnPropNameInRow="queestudia" msprop:Generator_ColumnPropNameInTable="queestudiaColumn" msprop:Generator_UserColumnName="queestudia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="horario" msprop:Generator_ColumnVarNameInTable="columnhorario" msprop:Generator_ColumnPropNameInRow="horario" msprop:Generator_ColumnPropNameInTable="horarioColumn" msprop:Generator_UserColumnName="horario" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="escuela" msprop:Generator_ColumnVarNameInTable="columnescuela" msprop:Generator_ColumnPropNameInRow="escuela" msprop:Generator_ColumnPropNameInTable="escuelaColumn" msprop:Generator_UserColumnName="escuela" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="idioma" msprop:Generator_ColumnVarNameInTable="columnidioma" msprop:Generator_ColumnPropNameInRow="idioma" msprop:Generator_ColumnPropNameInTable="idiomaColumn" msprop:Generator_UserColumnName="idioma" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="maquinasoficina" msprop:Generator_ColumnVarNameInTable="columnmaquinasoficina" msprop:Generator_ColumnPropNameInRow="maquinasoficina" msprop:Generator_ColumnPropNameInTable="maquinasoficinaColumn" msprop:Generator_UserColumnName="maquinasoficina" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="habilidadescomputacionales" msprop:Generator_ColumnVarNameInTable="columnhabilidadescomputacionales" msprop:Generator_ColumnPropNameInRow="habilidadescomputacionales" msprop:Generator_ColumnPropNameInTable="habilidadescomputacionalesColumn" msprop:Generator_UserColumnName="habilidadescomputacionales" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cursostomados" msprop:Generator_ColumnVarNameInTable="columncursostomados" msprop:Generator_ColumnPropNameInRow="cursostomados" msprop:Generator_ColumnPropNameInTable="cursostomadosColumn" msprop:Generator_UserColumnName="cursostomados" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="yatrabajoenpuesto" msprop:Generator_ColumnVarNameInTable="columnyatrabajoenpuesto" msprop:Generator_ColumnPropNameInRow="yatrabajoenpuesto" msprop:Generator_ColumnPropNameInTable="yatrabajoenpuestoColumn" msprop:Generator_UserColumnName="yatrabajoenpuesto" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="experiencia" msprop:Generator_ColumnVarNameInTable="columnexperiencia" msprop:Generator_ColumnPropNameInRow="experiencia" msprop:Generator_ColumnPropNameInTable="experienciaColumn" msprop:Generator_UserColumnName="experiencia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="empresasimilar" msprop:Generator_ColumnVarNameInTable="columnempresasimilar" msprop:Generator_ColumnPropNameInRow="empresasimilar" msprop:Generator_ColumnPropNameInTable="empresasimilarColumn" msprop:Generator_UserColumnName="empresasimilar" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="afiliadoimss" msprop:Generator_ColumnVarNameInTable="columnafiliadoimss" msprop:Generator_ColumnPropNameInRow="afiliadoimss" msprop:Generator_ColumnPropNameInTable="afiliadoimssColumn" msprop:Generator_UserColumnName="afiliadoimss" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="rfc" msprop:Generator_ColumnVarNameInTable="columnrfc" msprop:Generator_ColumnPropNameInRow="rfc" msprop:Generator_ColumnPropNameInTable="rfcColumn" msprop:Generator_UserColumnName="rfc" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="curp" msprop:Generator_ColumnVarNameInTable="columncurp" msprop:Generator_ColumnPropNameInRow="curp" msprop:Generator_ColumnPropNameInTable="curpColumn" msprop:Generator_UserColumnName="curp" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="licencia" msprop:Generator_ColumnVarNameInTable="columnlicencia" msprop:Generator_ColumnPropNameInRow="licencia" msprop:Generator_ColumnPropNameInTable="licenciaColumn" msprop:Generator_UserColumnName="licencia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tipolicencia" msprop:Generator_ColumnVarNameInTable="columntipolicencia" msprop:Generator_ColumnPropNameInRow="tipolicencia" msprop:Generator_ColumnPropNameInTable="tipolicenciaColumn" msprop:Generator_UserColumnName="tipolicencia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cartilla" msprop:Generator_ColumnVarNameInTable="columncartilla" msprop:Generator_ColumnPropNameInRow="cartilla" msprop:Generator_ColumnPropNameInTable="cartillaColumn" msprop:Generator_UserColumnName="cartilla" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cartillanumero" msprop:Generator_ColumnVarNameInTable="columncartillanumero" msprop:Generator_ColumnPropNameInRow="cartillanumero" msprop:Generator_ColumnPropNameInTable="cartillanumeroColumn" msprop:Generator_UserColumnName="cartillanumero" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="casapropia" msprop:Generator_ColumnVarNameInTable="columncasapropia" msprop:Generator_ColumnPropNameInRow="casapropia" msprop:Generator_ColumnPropNameInTable="casapropiaColumn" msprop:Generator_UserColumnName="casapropia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="casarentada" msprop:Generator_ColumnVarNameInTable="columncasarentada" msprop:Generator_ColumnPropNameInRow="casarentada" msprop:Generator_ColumnPropNameInTable="casarentadaColumn" msprop:Generator_UserColumnName="casarentada" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="casaprestada" msprop:Generator_ColumnVarNameInTable="columncasaprestada" msprop:Generator_ColumnPropNameInRow="casaprestada" msprop:Generator_ColumnPropNameInTable="casaprestadaColumn" msprop:Generator_UserColumnName="casaprestada" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tiempoviviendo" msprop:Generator_ColumnVarNameInTable="columntiempoviviendo" msprop:Generator_ColumnPropNameInRow="tiempoviviendo" msprop:Generator_ColumnPropNameInTable="tiempoviviendoColumn" msprop:Generator_UserColumnName="tiempoviviendo" type="xs:int" minOccurs="0" />
              <xs:element name="vivecon" msprop:Generator_ColumnVarNameInTable="columnvivecon" msprop:Generator_ColumnPropNameInRow="vivecon" msprop:Generator_ColumnPropNameInTable="viveconColumn" msprop:Generator_UserColumnName="vivecon" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="otroingreso" msprop:Generator_ColumnVarNameInTable="columnotroingreso" msprop:Generator_ColumnPropNameInRow="otroingreso" msprop:Generator_ColumnPropNameInTable="otroingresoColumn" msprop:Generator_UserColumnName="otroingreso" type="xs:decimal" minOccurs="0" />
              <xs:element name="personasdependientes" msprop:Generator_ColumnVarNameInTable="columnpersonasdependientes" msprop:Generator_ColumnPropNameInRow="personasdependientes" msprop:Generator_ColumnPropNameInTable="personasdependientesColumn" msprop:Generator_UserColumnName="personasdependientes" type="xs:int" minOccurs="0" />
              <xs:element name="gastosmensuales" msprop:Generator_ColumnVarNameInTable="columngastosmensuales" msprop:Generator_ColumnPropNameInRow="gastosmensuales" msprop:Generator_ColumnPropNameInTable="gastosmensualesColumn" msprop:Generator_UserColumnName="gastosmensuales" type="xs:decimal" minOccurs="0" />
              <xs:element name="aportacionhogar" msprop:Generator_ColumnVarNameInTable="columnaportacionhogar" msprop:Generator_ColumnPropNameInRow="aportacionhogar" msprop:Generator_ColumnPropNameInTable="aportacionhogarColumn" msprop:Generator_UserColumnName="aportacionhogar" type="xs:decimal" minOccurs="0" />
              <xs:element name="automovilpropio" msprop:Generator_ColumnVarNameInTable="columnautomovilpropio" msprop:Generator_ColumnPropNameInRow="automovilpropio" msprop:Generator_ColumnPropNameInTable="automovilpropioColumn" msprop:Generator_UserColumnName="automovilpropio" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="modeloauto" msprop:Generator_ColumnVarNameInTable="columnmodeloauto" msprop:Generator_ColumnPropNameInRow="modeloauto" msprop:Generator_ColumnPropNameInTable="modeloautoColumn" msprop:Generator_UserColumnName="modeloauto" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tienecredito" msprop:Generator_ColumnVarNameInTable="columntienecredito" msprop:Generator_ColumnPropNameInRow="tienecredito" msprop:Generator_ColumnPropNameInTable="tienecreditoColumn" msprop:Generator_UserColumnName="tienecredito" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="deudas" msprop:Generator_ColumnVarNameInTable="columndeudas" msprop:Generator_ColumnPropNameInRow="deudas" msprop:Generator_ColumnPropNameInTable="deudasColumn" msprop:Generator_UserColumnName="deudas" type="xs:decimal" minOccurs="0" />
              <xs:element name="abonomensual" msprop:Generator_ColumnVarNameInTable="columnabonomensual" msprop:Generator_ColumnPropNameInRow="abonomensual" msprop:Generator_ColumnPropNameInTable="abonomensualColumn" msprop:Generator_UserColumnName="abonomensual" type="xs:decimal" minOccurs="0" />
              <xs:element name="salud" msprop:Generator_ColumnVarNameInTable="columnsalud" msprop:Generator_ColumnPropNameInRow="salud" msprop:Generator_ColumnPropNameInTable="saludColumn" msprop:Generator_UserColumnName="salud" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="enfermedadcronica" msprop:Generator_ColumnVarNameInTable="columnenfermedadcronica" msprop:Generator_ColumnPropNameInRow="enfermedadcronica" msprop:Generator_ColumnPropNameInTable="enfermedadcronicaColumn" msprop:Generator_UserColumnName="enfermedadcronica" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cualcronica" msprop:Generator_ColumnVarNameInTable="columncualcronica" msprop:Generator_ColumnPropNameInRow="cualcronica" msprop:Generator_ColumnPropNameInTable="cualcronicaColumn" msprop:Generator_UserColumnName="cualcronica" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="enfermedadqueimpida" msprop:Generator_ColumnVarNameInTable="columnenfermedadqueimpida" msprop:Generator_ColumnPropNameInRow="enfermedadqueimpida" msprop:Generator_ColumnPropNameInTable="enfermedadqueimpidaColumn" msprop:Generator_UserColumnName="enfermedadqueimpida" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cualimpida" msprop:Generator_ColumnVarNameInTable="columncualimpida" msprop:Generator_ColumnPropNameInRow="cualimpida" msprop:Generator_ColumnPropNameInTable="cualimpidaColumn" msprop:Generator_UserColumnName="cualimpida" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="enfermedadcontagiosa" msprop:Generator_ColumnVarNameInTable="columnenfermedadcontagiosa" msprop:Generator_ColumnPropNameInRow="enfermedadcontagiosa" msprop:Generator_ColumnPropNameInTable="enfermedadcontagiosaColumn" msprop:Generator_UserColumnName="enfermedadcontagiosa" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cualcontagiosa" msprop:Generator_ColumnVarNameInTable="columncualcontagiosa" msprop:Generator_ColumnPropNameInRow="cualcontagiosa" msprop:Generator_ColumnPropNameInTable="cualcontagiosaColumn" msprop:Generator_UserColumnName="cualcontagiosa" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cuantasincapacidades" msprop:Generator_ColumnVarNameInTable="columncuantasincapacidades" msprop:Generator_ColumnPropNameInRow="cuantasincapacidades" msprop:Generator_ColumnPropNameInTable="cuantasincapacidadesColumn" msprop:Generator_UserColumnName="cuantasincapacidades" type="xs:int" minOccurs="0" />
              <xs:element name="motivoincapacidad" msprop:Generator_ColumnVarNameInTable="columnmotivoincapacidad" msprop:Generator_ColumnPropNameInRow="motivoincapacidad" msprop:Generator_ColumnPropNameInTable="motivoincapacidadColumn" msprop:Generator_UserColumnName="motivoincapacidad" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="consumirdroga" msprop:Generator_ColumnVarNameInTable="columnconsumirdroga" msprop:Generator_ColumnPropNameInRow="consumirdroga" msprop:Generator_ColumnPropNameInTable="consumirdrogaColumn" msprop:Generator_UserColumnName="consumirdroga" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tipodroga" msprop:Generator_ColumnVarNameInTable="columntipodroga" msprop:Generator_ColumnPropNameInRow="tipodroga" msprop:Generator_ColumnPropNameInTable="tipodrogaColumn" msprop:Generator_UserColumnName="tipodroga" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fuma" msprop:Generator_ColumnVarNameInTable="columnfuma" msprop:Generator_ColumnPropNameInRow="fuma" msprop:Generator_ColumnPropNameInTable="fumaColumn" msprop:Generator_UserColumnName="fuma" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tomaalcohol" msprop:Generator_ColumnVarNameInTable="columntomaalcohol" msprop:Generator_ColumnPropNameInRow="tomaalcohol" msprop:Generator_ColumnPropNameInTable="tomaalcoholColumn" msprop:Generator_UserColumnName="tomaalcohol" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="metacorto" msprop:Generator_ColumnVarNameInTable="columnmetacorto" msprop:Generator_ColumnPropNameInRow="metacorto" msprop:Generator_ColumnPropNameInTable="metacortoColumn" msprop:Generator_UserColumnName="metacorto" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="metamediando" msprop:Generator_ColumnVarNameInTable="columnmetamediando" msprop:Generator_ColumnPropNameInRow="metamediando" msprop:Generator_ColumnPropNameInTable="metamediandoColumn" msprop:Generator_UserColumnName="metamediando" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="metalargo" msprop:Generator_ColumnVarNameInTable="columnmetalargo" msprop:Generator_ColumnPropNameInRow="metalargo" msprop:Generator_ColumnPropNameInTable="metalargoColumn" msprop:Generator_UserColumnName="metalargo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="examenesdroga" msprop:Generator_ColumnVarNameInTable="columnexamenesdroga" msprop:Generator_ColumnPropNameInRow="examenesdroga" msprop:Generator_ColumnPropNameInTable="examenesdrogaColumn" msprop:Generator_UserColumnName="examenesdroga" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="comentarios" msprop:Generator_ColumnVarNameInTable="columncomentarios" msprop:Generator_ColumnPropNameInRow="comentarios" msprop:Generator_ColumnPropNameInTable="comentariosColumn" msprop:Generator_UserColumnName="comentarios" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="casapadres" msprop:Generator_ColumnVarNameInTable="columncasapadres" msprop:Generator_ColumnPropNameInRow="casapadres" msprop:Generator_ColumnPropNameInTable="casapadresColumn" msprop:Generator_UserColumnName="casapadres" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cualotradroga" msprop:Generator_ColumnVarNameInTable="columncualotradroga" msprop:Generator_ColumnPropNameInRow="cualotradroga" msprop:Generator_ColumnPropNameInTable="cualotradrogaColumn" msprop:Generator_UserColumnName="cualotradroga" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="salariodeseado" msprop:Generator_ColumnVarNameInTable="columnsalariodeseado" msprop:Generator_ColumnPropNameInRow="salariodeseado" msprop:Generator_ColumnPropNameInTable="salariodeseadoColumn" msprop:Generator_UserColumnName="salariodeseado" type="xs:decimal" minOccurs="0" />
              <xs:element name="disponibilidadhorario" msprop:Generator_ColumnVarNameInTable="columndisponibilidadhorario" msprop:Generator_ColumnPropNameInRow="disponibilidadhorario" msprop:Generator_ColumnPropNameInTable="disponibilidadhorarioColumn" msprop:Generator_UserColumnName="disponibilidadhorario" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="disponibilidadviajar" msprop:Generator_ColumnVarNameInTable="columndisponibilidadviajar" msprop:Generator_ColumnPropNameInRow="disponibilidadviajar" msprop:Generator_ColumnPropNameInTable="disponibilidadviajarColumn" msprop:Generator_UserColumnName="disponibilidadviajar" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Persona" msprop:Generator_TableClassName="PersonaDataTable" msprop:Generator_TableVarName="tablePersona" msprop:Generator_TablePropName="Persona" msprop:Generator_RowDeletingName="PersonaRowDeleting" msprop:Generator_UserTableName="Persona" msprop:Generator_RowChangingName="PersonaRowChanging" msprop:Generator_RowEvHandlerName="PersonaRowChangeEventHandler" msprop:Generator_RowDeletedName="PersonaRowDeleted" msprop:Generator_RowEvArgName="PersonaRowChangeEvent" msprop:Generator_RowChangedName="PersonaRowChanged" msprop:Generator_RowClassName="PersonaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idpersona" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnidpersona" msprop:Generator_ColumnPropNameInRow="idpersona" msprop:Generator_ColumnPropNameInTable="idpersonaColumn" msprop:Generator_UserColumnName="idpersona" type="xs:string" />
              <xs:element name="nombre1" msprop:Generator_ColumnVarNameInTable="columnnombre1" msprop:Generator_ColumnPropNameInRow="nombre1" msprop:Generator_ColumnPropNameInTable="nombre1Column" msprop:Generator_UserColumnName="nombre1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nombre2" msprop:Generator_ColumnVarNameInTable="columnnombre2" msprop:Generator_ColumnPropNameInRow="nombre2" msprop:Generator_ColumnPropNameInTable="nombre2Column" msprop:Generator_UserColumnName="nombre2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="apellido1" msprop:Generator_ColumnVarNameInTable="columnapellido1" msprop:Generator_ColumnPropNameInRow="apellido1" msprop:Generator_ColumnPropNameInTable="apellido1Column" msprop:Generator_UserColumnName="apellido1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="apellido2" msprop:Generator_ColumnVarNameInTable="columnapellido2" msprop:Generator_ColumnPropNameInRow="apellido2" msprop:Generator_ColumnPropNameInTable="apellido2Column" msprop:Generator_UserColumnName="apellido2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="calle" msprop:Generator_ColumnVarNameInTable="columncalle" msprop:Generator_ColumnPropNameInRow="calle" msprop:Generator_ColumnPropNameInTable="calleColumn" msprop:Generator_UserColumnName="calle" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="colonia" msprop:Generator_ColumnVarNameInTable="columncolonia" msprop:Generator_ColumnPropNameInRow="colonia" msprop:Generator_ColumnPropNameInTable="coloniaColumn" msprop:Generator_UserColumnName="colonia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="municipio" msprop:Generator_ColumnVarNameInTable="columnmunicipio" msprop:Generator_ColumnPropNameInRow="municipio" msprop:Generator_ColumnPropNameInTable="municipioColumn" msprop:Generator_UserColumnName="municipio" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cp" msprop:Generator_ColumnVarNameInTable="columncp" msprop:Generator_ColumnPropNameInRow="cp" msprop:Generator_ColumnPropNameInTable="cpColumn" msprop:Generator_UserColumnName="cp" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="telefono1" msprop:Generator_ColumnVarNameInTable="columntelefono1" msprop:Generator_ColumnPropNameInRow="telefono1" msprop:Generator_ColumnPropNameInTable="telefono1Column" msprop:Generator_UserColumnName="telefono1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="telefono2" msprop:Generator_ColumnVarNameInTable="columntelefono2" msprop:Generator_ColumnPropNameInRow="telefono2" msprop:Generator_ColumnPropNameInTable="telefono2Column" msprop:Generator_UserColumnName="telefono2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="celular1" msprop:Generator_ColumnVarNameInTable="columncelular1" msprop:Generator_ColumnPropNameInRow="celular1" msprop:Generator_ColumnPropNameInTable="celular1Column" msprop:Generator_UserColumnName="celular1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="celular2" msprop:Generator_ColumnVarNameInTable="columncelular2" msprop:Generator_ColumnPropNameInRow="celular2" msprop:Generator_ColumnPropNameInTable="celular2Column" msprop:Generator_UserColumnName="celular2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fechaalta" msprop:Generator_ColumnVarNameInTable="columnfechaalta" msprop:Generator_ColumnPropNameInRow="fechaalta" msprop:Generator_ColumnPropNameInTable="fechaaltaColumn" msprop:Generator_UserColumnName="fechaalta" type="xs:dateTime" minOccurs="0" />
              <xs:element name="fechanacimiento" msprop:Generator_ColumnVarNameInTable="columnfechanacimiento" msprop:Generator_ColumnPropNameInRow="fechanacimiento" msprop:Generator_ColumnPropNameInTable="fechanacimientoColumn" msprop:Generator_UserColumnName="fechanacimiento" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ciudadnacimiento" msprop:Generator_ColumnVarNameInTable="columnciudadnacimiento" msprop:Generator_ColumnPropNameInRow="ciudadnacimiento" msprop:Generator_ColumnPropNameInTable="ciudadnacimientoColumn" msprop:Generator_UserColumnName="ciudadnacimiento" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="paisnacimiento" msprop:Generator_ColumnVarNameInTable="columnpaisnacimiento" msprop:Generator_ColumnPropNameInRow="paisnacimiento" msprop:Generator_ColumnPropNameInTable="paisnacimientoColumn" msprop:Generator_UserColumnName="paisnacimiento" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="comentarios" msprop:Generator_ColumnVarNameInTable="columncomentarios" msprop:Generator_ColumnPropNameInRow="comentarios" msprop:Generator_ColumnPropNameInTable="comentariosColumn" msprop:Generator_UserColumnName="comentarios" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="activo" msprop:Generator_ColumnVarNameInTable="columnactivo" msprop:Generator_ColumnPropNameInRow="activo" msprop:Generator_ColumnPropNameInTable="activoColumn" msprop:Generator_UserColumnName="activo" type="xs:boolean" minOccurs="0" />
              <xs:element name="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnPropNameInTable="emailColumn" msprop:Generator_UserColumnName="email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Candidato" />
      <xs:field xpath="mstns:idcandidato" />
    </xs:unique>
    <xs:unique name="Curriculum_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Curriculum" />
      <xs:field xpath="mstns:idcurriculum" />
    </xs:unique>
    <xs:unique name="EntrevistaCosea_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:EntrevistaCosea" />
      <xs:field xpath="mstns:identrecosea" />
    </xs:unique>
    <xs:unique name="Persona_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Persona" />
      <xs:field xpath="mstns:idpersona" />
    </xs:unique>
  </xs:element>
</xs:schema>